Nuno Lucas <ntlu...@gmail.com> writes: > On Tue, May 26, 2009 at 5:17 PM, Nikolaus Rath <nikol...@rath.org> wrote: >> Hello, >> >> How can I determine the rowid of the last insert if I am accessing the >> db from different threads? If I understand correctly, >> last_insert_rowid() won't work reliably in this case. > > It should work if you do: > > BEGIN > INSERT ... > last_insert_rowid() > END
That would be very nice. But does "it should work" mean that you know that it works (and it is documented and guaranteed)? The above sounds a bit uncertain to me... Thanks for the clarification, -Nikolaus -- »Time flies like an arrow, fruit flies like a Banana.« PGP fingerprint: 5B93 61F8 4EA2 E279 ABF6 02CF A9AD B7F8 AE4E 425C _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users