On 28 Jun 2016, at 4:56pm, R Smith <[email protected]> wrote: > I am not clear on what happens for INSERT OR REPLACE results when a row gets > updated in stead of inserted, but the documentation should have details.
In SQLite, the REPLACE operation really does delete the original and insert a new row. So last_insert_rowid() will work correctly with it. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
