Baruch Burstein wrote: > sqlite> select last_insert_rowid(); > 2 > sqlite> rollback; > sqlite> select last_insert_rowid(); > 2 > > In other words, the rollback doesn't roll back the rowid.
<http://www.sqlite.org/c3ref/last_insert_rowid.html> says: | For the purposes of this routine, an INSERT is considered | to be successful even if it is subsequently rolled back. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users