Regarding: "I'm aware of the create table syntax. And according to it I can declare a column as INTEGER AUTO_INCREMENT NOT NULL. So I wonder why this doesn't work (in MySQL it does!)."
To underscore -- the difficulty: Maybe it was just a typing mistake in your message, but according to http://sqlite.org/lang_createtable.html The keyword is AUTOINCREMENT and not AUTO_INCREMENT ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------