Hi, all,
Is it reliable/portable/well-defined to use (read-only) the sqlite_sequence
table to find the last insertion ID for a given table? i know about
sqlite3_last_insert_id(), but i'm wondering if reading the sqlite_sequence
table directly might be safer vis-a-vis triggers which perform an insert
(and thereby cause sqlite3_last_insert_id() to possibly return an
unexpected value).
Take from a db dump:
DELETE FROM sqlite_sequence;
INSERT INTO "sqlite_sequence" VALUES('t',8);
:-?
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
