Karl Lautman <[EMAIL PROTECTED]> wrote: > So, I create a table as follows: > > CREATE TABLE IF NOT EXISTS Lists ( > wID integer, > ltitle text, > llink text, > units text, > date text, > ListsID integer, > new integer > , CONSTRAINT Lists_pk PRIMARY KEY (ListsID))
Be aware that, in order to create a column that aliases ROWID (and thus has special properties in SQLite, such as getting an automatically assigned unique integer) it has to be spelled precisely INTEGER PRIMARY KEY. Doing it the way you show, with a CONSTRAINT clause, won't do the trick. Make it CREATE TABLE IF NOT EXISTS Lists ( wID integer, ltitle text, llink text, units text, date text, ListsID integer primary key, new integer); Scott Baker already addressed the rest of your problem. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users