I have the following table creation statements and get an error. Scenario:
Functioning statement CREATE TABLE xxx (ID INTEGERPRIMARY KEY AUTOINCREMENT, .) If I remove the PRIMARY KEY" part of the statement, according to the docs on SQL that should be still a valid statement, I get an error. Brken statement: CREATE TABLE zzz (ID INTEGER AUTOINCREMENT .); But, if I change "AUTOINCREMENT "AUTO_INCREMENT" it works Functioning statement: CREATE TABLE zzz (ID INTEGER AUTO_INCREMENT .); Did this get changed in SQL and I'm just not aware of it? Should I use "AUTO_INCRMENT" verywhere now? If it has change shouldn't the parser be consistant about it? <grin> Thanks, J. R. -------------------- J. R. Westmoreland E-mail: j...@jrw.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
