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 <[email protected]> To: General Discussion of SQLite Database <[email protected]> Date: 23/08/2011 15.42 Subject: Re: [sqlite] Autoincrement failure On Tue, Aug 23, 2011 at 9:35 AM, <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
