Re: [sqlite] last_insert_rowid() question

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/27/2010 11:41 AM, Scott A Mintz wrote: I know that I can use sqlite3_last_insert_rowid() to retrieve the value. However, in a multi-threaded environment, it's possible for another thread to do an INSERT before I get the first result.

Re: [sqlite] Rollback transaction if error

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/27/2010 06:37 PM, BareFeetWare wrote: Yes, I know that in my application code I can step through each command in the transaction, check for an error, and if there is an error, end the transaction with a rollback instead of a commit. What