Re: [sqlite] problem with INTEGER PRIMARY KEY ASC AUTOINCREMENT column

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

Re: [sqlite] problem with INTEGER PRIMARY KEY ASC AUTOINCREMENT column

On 10/20/08, Kenneth McDonald <[EMAIL PROTECTED]> wrote: > 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

Re: [sqlite] problem with INTEGER PRIMARY KEY ASC AUTOINCREMENT column

some sql examples would help, With out that I will attempt an answer. 1. Could be that you are including your auto increment field in the list of fields. So just don't reference the field, it will be done automatically. 2. Or you could be msiing the field list all together and just supplying

[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