Kurt Welgehausen wrote:
begin immediate; insert; select max(id) from blah; commit;
Or "select last_insert_rowid() from blah limit 1"
Regards
Better yet
select last_insert_rowid();
The from clause is not needed and may imply that SQLite keeps the last inserted rowid for each table, which it does not. The limit clause is also unnecessary since the last_insert_rowid function always returns a single result.
HTH Dennis Cote
