creation statement is "CREATE TABLE Journal (ClosureNum INTEGER, TicketNum INTEGER, ItemNum INTEGER, Date DATE, Time TIME, Item BLOB, PRIMARY KEY(ClosureNum, TicketNum, ItemNum))"
Autoincrement seems to work fine Thanks for your support Alessandro From: Richard Hipp <d...@sqlite.org> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Date: 23/08/2011 15.42 Subject: Re: [sqlite] Autoincrement failure On Tue, Aug 23, 2011 at 9:35 AM, <a.azzol...@custom.it> wrote: > IMy table has three primary key, autoincrement active and other description > column like > The AUTOINCREMENT feature of SQLite only works if there is a single INTEGER PRIMARY KEY. Please send us the text of the CREATE TABLE statement for your table so that we can better advise you. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users