Brass Tilde wrote:
>> You probably meant to say:
>>
>>      select last_insert_rowid()
>>
>> That is, without the FROM clause.
>
> And as long as I do that immediately after inserting to the table,
> with no intervening inserts to other tables, I suspect that will
> work.  Fortunately, I have the luxury of writing a single user,
> single threaded app.

Of course if you don't have that luxury, then you would have to do the
insert and select inside a transaction to ensure that no other thread does
another insert between the two statements.

Reply via email to