What does your insert statement look like? ------Original Message------ From: Kenneth McDonald Sender: [EMAIL PROTECTED] To: sqlite-users@sqlite.org ReplyTo: General Discussion of SQLite Database Sent: Oct 20, 2008 10:23 Subject: [sqlite] problem with INTEGER PRIMARY KEY ASC AUTOINCREMENT column
Basically, my database INSERT commands seem to still expect a value for this, even though my expectation is that it will be computed automatically, starting with (I assume) a default of 0 or 1. But I'm getting errors of the sort "table images has 12 columns but 11 values were supplied." Is there something else I need to do to have the primary key column computed automatically? Thanks, Ken _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Timothy A. Sawyer, CISSP Managing Director MBD Solutions Phone: (603) 546-7132 Web: http://www.mybowlingdiary.com Email: [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
