Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
GetCreateTableStatement and ADS Database |
Thu, May 16 2019 2:02 PM | Permanent Link |
Ozgur Aral Johnson Controls | I'm trying to use function GetCreateTableStatement to convert an Advantage Database to ElevateDB but the SQL result generate the following error.
CREATE TABLE "accesslevel" ( "PkData" Integer, "FkObject" Integer, "FkParent" Integer, "MasterAccount" Integer, "Account" Integer, "Cluster" Integer, "NTM" Integer, "GSI" Integer, "Site" Integer, "Info1" Integer, "Info2" Integer, "Info3" Integer, "Info4" Integer, "State" SmallInt, "TransactionId" Integer, "TransactionTag" Timestamp, "Description1" VarChar(100) COLLATE "UNI", "Description2" VarChar(100) COLLATE "UNI", "NoneValid" SmallInt, "AllValid" SmallInt, "ItemCount" Integer, "Type" SmallInt, "XMLData" CLOB COLLATE "UNI", CONSTRAINT "PRIMARY" UNIQUE ("PKDATA"), CONSTRAINT "SKD1_ACCESSLEVEL" UNIQUE ("MASTERACCOUNT","ACCOUNT","DESCRIPTION1","PKDATA"), CONSTRAINT "SKD2_ACCESSLEVEL" UNIQUE ("MASTERACCOUNT","ACCOUNT","DESCRIPTION2","PKDATA") Attachments: SQLError.png |
Fri, May 17 2019 7:32 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Ozgur
Sorry I can't help. I've tried your statement in EDBManager in both Unicode and ANSI and the only problem in either is a missing final ) I suspect the sql you're running isn't the same as what you posted. Roy Lambert |
Mon, May 20 2019 2:07 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ozgur,
<< I'm trying to use function GetCreateTableStatement to convert an Advantage Database to ElevateDB but the SQL result generate the following error. >> Where are you getting the GetCreateTableStatement function from ? The Advantage Database SQL may or may not necessarily be usable from within ElevateDB. You may need to massage some of the SQL statements so that they are acceptable by ElevateDB. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |