I am getting this error on the SQL statement below...

'DBISAM Engine Error #11929 SQL parsing error - Expected column name but
instead found "ABT_FULLNAME" in CREATE INDEX SQL statement at
line 40, column 65

Here is the SQL , which BTW is generated using DBSys 'reverse engineer',
saved to a .sql file and loaded at runtime
Using DBisam 4.27

/* SQL-92 Table Creation Script with DBISAM Extensions */

CREATE TABLE IF NOT EXISTS "Table_AddressBook"
(
  "ABT_INDEX" AUTOINC,
  "ABT_LASTNAME" VARCHAR(30),
  "ABT_FIRSTNAME" VARCHAR(30),
  "ABT_MIDDLENAME" VARCHAR(30),
  "ABT_FULLNAME" VARCHAR(100),
  "ABT_ALIAS" VARCHAR(50),
  "ABT_ADDRESS" MEMO,
  "ABT_FAXPHONE" VARCHAR(50),
  "ABT_REGPHONE" VARCHAR(50),
  "ABT_EMAIL" VARCHAR(80),
  "ABT_GROUP" MEMO,
  "ABT_COMPANY" VARCHAR(40),
  "ABT_LASTFAXTO" TIMESTAMP,
  "ABT_LASTFAXFROM" TIMESTAMP,
  "ABT_NOTES" VARCHAR(250),
  "ABT_FORWARDTOEMAIL" BOOLEAN,
  "ABT_FORWARDFAX" BOOLEAN,
  "ABT_WEBNOTIFY" BOOLEAN,
PRIMARY KEY ("ABT_INDEX") COMPRESS NONE
TEXT INDEX ("ABT_ADDRESS","ABT_GROUP")
STOP WORDS 'A AN AND BE FOR HOW IN IS IT OF ON OR THAT THE THIS TO WAS WHAT
WHEN WHICH WHY WILL'
SPACE CHARS #1+#2+#3+#4+#5+#6+#7+#8+#9+#10+#11+#12+#13
+#14+#15+#16+#17+#18+#19+#20+#21+#22+#23
+#24+#25+#26+#27+#28+#29+#30+#31+#32+'*+'+
',-./:;<=>\`'
INCLUDE CHARS '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ_ab'+
'cdefghijklmnopqrstuvwxyz?�,f".??^?S<O�Z�'+
'�''"".--~Ts>o�zY ¡¢£¤¥¦§¨©ª«¬­®¯°±²³´µ¶·'+
'¸¹º»¼½¾¿ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞß'+
'àáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþ'
DESCRIPTION 'Address Book Table'
LOCALE CODE 0
USER MAJOR VERSION 1
);

CREATE INDEX IF NOT EXISTS "byFullName" ON "Table_AddressBook"
("ABT_FULLNAME") COMPRESS TRAILBYTE;
CREATE INDEX IF NOT EXISTS "byFaxPhone" ON "Table_AddressBook"
("ABT_FAXPHONE") COMPRESS TRAILBYTE;
CREATE INDEX IF NOT EXISTS "ByEmail" ON "Table_AddressBook" ("ABT_EMAIL")
COMPRESS TRAILBYTE;
CREATE INDEX IF NOT EXISTS "ByCompany" ON "Table_AddressBook"
("ABT_COMPANY") COMPRESS TRAILBYTE;
CREATE INDEX IF NOT EXISTS "ByLastFaxTo" ON "Table_AddressBook"
("ABT_LASTFAXTO");
CREATE INDEX IF NOT EXISTS "byLastFaxfrom" ON "Table_AddressBook"
("ABT_LASTFAXFROM");

Can someone please enlighten me ?

Thanks
JT

"John Taylor" <jcta@snappysoftware.com> wrote in message
news:684B83C8-05D0-4FFD-A1E5-EE83D90A42DF@news.elevatesoft.com...
>I am getting this error on the SQL statement below...
>

Runs fine on DBsys 4.25. Is it possible that you have a line break where it
does not belong? Load it and take a look at the SQL using the debugger.

Robert

Curiously, the problem only manifests itself when the data files already
exists in the
database folder, if I first delete the dat and idx files in that folder
before executing
then the exception is not raised.  I have not tried it in dbsys (next to do)
but the file was created
with dbsys, saved to file, not touched and then loaded via
Query.sql.loadfromfile


"Robert" <ngsemail2005withoutthis@yahoo.com.ar> wrote in message
news:3320F0C8-9FED-4087-8D74-A2953AC5107F@news.elevatesoft.com...
>
> "John Taylor" <jcta@snappysoftware.com> wrote in message
> news:684B83C8-05D0-4FFD-A1E5-EE83D90A42DF@news.elevatesoft.com...
>>I am getting this error on the SQL statement below...
>>
>
> Runs fine on DBsys 4.25. Is it possible that you have a line break where
> it does not belong? Load it and take a look at the SQL using the debugger.
>
> Robert
>

John
> I am getting this error on the SQL statement below...
>
> 'DBISAM Engine Error #11929 SQL parsing error - Expected column name but
> instead found "ABT_FULLNAME" in CREATE INDEX SQL statement at
> line 40, column 65
> Can someone please enlighten me ?

If the table name "Table_AddressBook" already exists without the field
abt_fullname you would get this error.

John

"John Taylor" <jcta@snappysoftware.com> wrote in message
news:B8ACE5FC-DAB3-4D06-B8D8-E4B51F6EBEFA@news.elevatesoft.com...
> Curiously, the problem only manifests itself when the data files already
> exists in the
> database folder,

runs fine multiple times usisng DBsys

if I first delete the dat and idx files in that folder
> before executing
> then the exception is not raised.  I have not tried it in dbsys (next to
> do) but the file was created
> with dbsys, saved to file, not touched and then loaded via
> Query.sql.loadfromfile
>

I suspect the bug is there, in the loadfromfile. One of the lines did not
get loaded correctly.

Robert

Thanks John and Robert !

I believe the problem is resolved


"John Hay" <j.haywithoutdot@crbsolutionsremoveallthis.co.uk> wrote in
message news:D3557337-8F5B-4041-BD10-496AEFAD372E@news.elevatesoft.com...
> John
>> I am getting this error on the SQL statement below...
>>
>> 'DBISAM Engine Error #11929 SQL parsing error - Expected column name but
>> instead found "ABT_FULLNAME" in CREATE INDEX SQL statement at
>> line 40, column 65
>> Can someone please enlighten me ?
>
> If the table name "Table_AddressBook" already exists without the field
> abt_fullname you would get this error.
>
> John
>
>