The tcl interface spec says:
> The "last_insert_rowid" method returns an integer which is the ROWID of
> the most recently inserted database row.
So if I have
db eval {CREATE TABLE t(the_key INTEGER PRIMARY KEY, data TEXT)}
and I
db eval {INSERT INTO t VALUES(NULL, 'foo')}
then does
db last_insert_rowid
reliably return the_key of the most recently inserted database row,
so that the returned value may safely (across vacuums etc) be used
as a foreign reference to t's the_key column?
Is this the best way of inserting a guaranteed non-conflicting row &
getting the new row's key?
--
Eric A. Smith
Money is the root of all wealth.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
