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.