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 <[email protected]> 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
