Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread Multiple commands in database creation
Wed, Nov 30 2016 9:27 AMPermanent Link

Matthew Jones

I have a script file that creates a table, and then some indexes.

CREATE TABLE "DocumentStore"
(
....
)
MAX BLOB BUFFER SIZE 32768
MAX PUBLISH BUFFER SIZE 32768!

CREATE INDEX "idxDocumentID" ON "DocumentStore" ("dsDocumentID" COLLATE "UNI_CI")!
CREATE INDEX "idxStoreName" ON "DocumentStore" ("dsStoreNameID")!

When I use the following code to run this (in the createSQL string), I get an error at the ! character.

EDBCommand DataCommand = new EDBCommand();
DataCommand.Connection = DataConnection;

DataCommand.CommandText = createSQL;
DataCommand.ExecuteNonQuery();


Is this even possible? Or should I just split it myself at the ! character? Or should I use something else?
Wed, Nov 30 2016 9:50 AMPermanent Link

Matthew Jones

Matthew Jones wrote:

> Or should I just split it myself at the ! character?

This appears to work, once I worked out the arcane C# .split function! Would like to know if there is a character to do it in EDB though.
Wed, Nov 30 2016 11:14 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Matthew

>> Or should I just split it myself at the ! character?

Yes

>This appears to work, once I worked out the arcane C# .split function! Would like to know if there is a character to do it in EDB though.

Not as far as I know. Using ! as a statement delimited works in EDBManager essentially because Tim parses it into lines.

Tim did do something about converting queries from the DBISAM format into something ElevateDB can use but I never used it and can't remember what it was and wether it was run time or design time.

Roy Lambert
Wed, Nov 30 2016 11:41 AMPermanent Link

Matthew Jones

Thanks, I can move on knowing I've not missed some magic solution.
Thu, Dec 1 2016 3:47 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Tim did do something about converting queries from the DBISAM format into something ElevateDB can use but I never used it and can't remember what it was and wether it was run time or design time. >>

It's in the TEDBScript component and is called ConvertSQL:

http://www.elevatesoft.com/manual?action=viewmethod&id=edb2&product=rsdelphi&version=XE&comp=TEDBScript&method=ConvertSQL

But, that's a little different from what Matthew is asking.  He's already using something that is easily parsed because it's not using an SQL separator character like the semicolon.

Tim Young
Elevate Software
www.elevatesoft.com
Thu, Dec 1 2016 3:48 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Matthew,

<< Is this even possible? Or should I just split it myself at the ! character? Or should I use something else? >>

Just split it yourself - that's what the EDB Manager does.

Tim Young
Elevate Software
www.elevatesoft.com
Image