"table images has 12 columns but 11 values were supplied." Probably because you're not listing the columns in your insert statement.
You may be doing Insert into foo values ( 'bar', 'baz', ... ) But you probably should do Insert into foo ( col1, col2, ... ) values ( 'value1', 'value2', ... ) Where the ... Stand for the other columns, but you get my drift. g -----Original Message----- From: Kenneth McDonald [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2008 12:24 PM To: sqlite-users@sqlite.org 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
