On 28 Jun 2016, at 4:56pm, R Smith <rsm...@rsweb.co.za> 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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users