Re: [sqlite] Re: Re: Updating two tables

2007-08-09 Thread Koen Vermeer
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 >

[sqlite] Re: Re: Updating two tables

2007-08-09 Thread Igor Tandetnik
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 inse