Hi!

I wanna Execute this:
CREATE TABLE TEMPxNLHBJDMB(KOD INTEGER,NEV VARCHAR(100));
CREATE INDEX "IDX1" ON "TEMPxNLHBJDMB" (KOD);
CREATE INDEX "IDX2" ON "TEMPxNLHBJDMB" (NEV);

But I got this error:

================================================================================
SQL Error (ElevateDB 1.04 Build 6)
================================================================================

ElevateDB Error #700 An error was found in the statement at line 3 and column 1
(Expected end of expression but instead found CREATE)

If I run every command in other SQL the problem vanished.
What I do wrong? Or separator changed from ";"?

Please help me!

Thanks: dd

Durumdara


ElevateDB does not supports scripts yet. I think support might be in 1.06. In the meantime you have to run reach statement separately.

Roy Lambert

Durumdara,

<< I wanna Execute this:
CREATE TABLE TEMPxNLHBJDMB(KOD INTEGER,NEV VARCHAR(100));
CREATE INDEX "IDX1" ON "TEMPxNLHBJDMB" (KOD);
CREATE INDEX "IDX2" ON "TEMPxNLHBJDMB" (NEV);

But I got this error: >>

Roy is correct - script support won't be available until 1.06 is out, which
hopefully won't be too much longer.

--
Tim Young
Elevate Software
www.elevatesoft.com