At 15:45 15/11/2013, you wrote:
last_insert_rowid() is needed for autoincremented keys.
WITHOUT ROWID tables do not have an autoincrementing key. Your program
has to generate or get the key in some other way, so it knows the value
even before the record is inserted.
last_insert_primary_key would nevertheless be very useful in triggers.
--
<mailto:j...@q-e-d.org>j...@antichoc.net
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
