-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 04/01/2015 10:10 AM, Kumar Suraj wrote: > Hi Richard.. this wont work for me due to following reason.
Yes it will. This is how I do it: BEGIN TRANSACTION; INSERT INTO table .....; SELECT last_insert_rowid(); COMMIT; That will always give the right answer no matter how concurrent your usage is. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iEYEARECAAYFAlUcTPwACgkQmOOfHg372QRmcwCgzSMaabaWvdQGIIa2cSH2UywX kHIAoN/ovfhvl54Qc/SbJ5NCDc/xb9CT =4iBF -----END PGP SIGNATURE-----