-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 03/08/2011 06:25 AM, Jay A. Kreibich wrote: > To be more specific, the sqlite_sequence table can be used to find > the lowest sequence number that *may* be assigned.
In the same situation as OP I wouldn't bother with trying to find out numbers in advance and instead just do the actual inserts then use last_insert_rowid to find out what was assigned (everything wrapped in a transaction to avoid concurrency issues). That will unambiguously always give the right answer no matter how sequences are implemented behind the scenes. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk12Y9oACgkQmOOfHg372QTYWACeMShDXs37teclf+ARNMfQuHNQ p6gAn17cm/oc3TsQVjLZV/UtRaDrB74T =W6xy -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
