Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Connectivity » View Thread |
Messages 1 to 6 of 6 total |
Multiple commands in database creation |
Wed, Nov 30 2016 9:27 AM | Permanent 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 AM | Permanent 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 AM | Permanent Link |
Roy Lambert NLH Associates 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 AM | Permanent Link |
Matthew Jones | Thanks, I can move on knowing I've not missed some magic solution.
|
Thu, Dec 1 2016 3:47 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Wednesday, March 27, 2024 at 05:29 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |