Subject to the same caveats as normal. It only returns the ROWID of the last insert on the connection. If you are ABOSLUTELY SURE without a dounbt that the last insert on the connection is the one that you want the rowid for, then it will work as you intend. However if you miscompute which insert is the last row inserted on the connection, you may get a result that confuses exceeds the understanding.
> -----Original Message----- > From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users- > boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin > Sent: Tuesday, 28 June, 2016 11:59 > To: SQLite mailing list > Subject: Re: [sqlite] How to use "cursors" in c# > > > 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users