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")

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

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