At 00:13 25/11/2017, you wrote:
Looks like I do need to use AUTOINCREMENT after all, otherwise the framework I'm using doesn't appear to recognize that INTEGER PRIMARY KEY columns are allowed a NULL value on insert.
I can't answer about just INTEGER PRIMARY KEY columns, but any table with an AUTOINCREMENT column has an entry in table sqlite_sequence, something much easier to deal with than digging into sqlite_master.
JcD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users