What is the correct nomenclature for using last_insert_rowid() for SQLite? For OLE DB I've used ... oledbCmd.CommandText = "Select @@Identity" ... int iKeyID = (int)oledbCmd.ExecuteScalar().
On Mon, Feb 6, 2017 at 7:24 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > Clyde Eisenbeis wrote: >> Perhaps there is no equivalence to OLE DB ... oledbCmd.CommandText = >> "Select @@Identity" ... int iKeyID = (int)oledbCmd.ExecuteScalar()? > > This has *nothing* to do with OLE DB; @@Identity is an SQL Server > specific thing. SQLite's is last_insert_rowid(), and both have > exactly the same restrictions. > > > Regards, > Clemens > _______________________________________________ > 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