When I use the following command string:
"CREATE TABLE tbl1 (Id INT CONSTRAINT PK_Id PRIMARY KEY
AUTOINCREMENT NOT NULL ,Name VARCHAR(20) )"
I get the following SQLite exception:
"AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY"
wherease no exception is thrown if INT in the command is changed to
INTEGER. As per the affinity rules, INT should be treated as INTEGER.
Thanks
Sanjiv
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
