Op donderdag 09-08-2007 om 14:01 uur [tijdzone -0400], schreef Igor Tandetnik: > > Yes, I did forget to mention: I would like to wrap the statements into > > one transaction. > Feel free to. Nothing I said would prevent you from doing that. > > Besides, doing an insert, select and again a number > > of > > inserts somehow feels wrong. > You don't need a select. Use sqlite3_last_insert_rowid API.
Thanks. I did some googling on the combination sqlite3_last_insert_rowid and transactions and found some old discussions that explained it in such a way that I think I understand how it works now. It basically boiled down to me not realizing that locks are acquired at the time of the insert statement (or earlier). Anyway, thanks for pointing me in the right direction! Best, Koen ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
