Koen Vermeer <[EMAIL PROTECTED]> wrote:
Op donderdag 09-08-2007 om 12:26 uur [tijdzone -0400], schreef Igor
Tandetnik:
I'm not sure I understand the problem. Can't you insert into A,
retrieve the last ID into a variable in your program, then use the
value of this variable for all subsequent inserts into B?
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.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
