2, ... ) 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] pr
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
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 "t
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 val
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
5 matches
Mail list logo