>>> Kevin Waterson <[EMAIL PROTECTED]> 20/10/2003 9:17:26 am >>>
I have a table that looks like this..
#
#SQLite Admin Structure Dump for table quotes
#
create table quotes(id INTEGER PRIMARY KEY, author varchar(50), quote TEXT, category
varchar(20))
I am trying to auto increment the id field with this query
INSERT INTO quotes (id, author, quote, category) VALUES ('NULL', 'blah', 'blah',
'blah')
instead, I get an error saying 'datatype mismatch'
INSERT INTO quotes (id, author, quote, category) VALUES (NULL, 'blah', 'blah', 'blah')
Remove the quotes around the NULL
Regards
IAN
This message is intended for the addressee named and may contain
confidential/privileged information. If you are not the intended recipient, please
delete it and notify the sender.
Views expressed in this message are those of the individual sender, and are not
necessarily the views of the Department.
You should scan any attached files for viruses.
