Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 4 of 4 total |
"CREATE TABLE" broken after upgrade to EDB 2.05 Build 14 |
Wed, Sep 28 2011 3:03 AM | Permanent Link |
TonyWood | Hi All,
I recently upgraded from 2.05 build 10 to build 14, and my Create Table queries have stopped working, e.g. CREATE TABLE "Promotion" ( "PromotionCode" INTEGER DESCRIPTION 'Promo number', "PromotionStatus" INTEGER DEFAULT 0 , "PromotionName" VARCHAR(40) COLLATE "ANSI_CI" ) DESCRIPTION 'Promotions' VERSION 1.00 READWRITE UNENCRYPTED ; gets ElevateDB Error #700 An error was found in the statement at line 9 and column 1 (Expected end of expression but instead found READWRITE) Has the syntax changed or is this a installation / configuration error on my part. Thanks in advance Tony Wood |
Wed, Sep 28 2011 3:38 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tony
Is there a build 14 - the latest announcement I've had is for build 11 on 25/8/11 Roy Lambert |
Wed, Sep 28 2011 4:15 AM | Permanent Link |
TonyWood | Good catch Roy, I've just downgraded to 203b14
sorry <sheepish grin> |
Wed, Sep 28 2011 4:53 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tony
So like me you keep all the previous versions? To make things easy on myself I have, for download, a DBISAM directory and an ElevateDB directory. The DBISAM is static but in the ElevateDB one I have a Version1 sub directory and a Version2 subdirectory. Prior to downloading the new version I move the last version into the Version2 subdirectory so only the latest version is directly in ElevateDB. Until Tim starts naming them something like Looney Leopard it saves wear and tear on my eyes. Roy Lambert |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |