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

Tony


Is there a build 14 - the latest announcement I've had is for build 11 on 25/8/11

Roy Lambert

Good catch Roy, I've just downgraded to 203b14

sorry <sheepish grin>

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