When I enter last_insert_rowid(), the compiler complains. I think last_insert_rowid() is SQLite3.
Is there an equivalent for System.Data.SQLite? On Fri, Feb 3, 2017 at 8:40 AM, Chris Locke <ch...@chrisjlocke.co.uk> wrote: > Last_insert_rowid() > > https://www.sqlite.org/c3ref/last_insert_rowid.html > > On Fri, Feb 3, 2017 at 1:51 PM, Clyde Eisenbeis <cte...@gmail.com> wrote: > >> For OLE DB SQL, I have retrieved the primary key: >> >> ----------------------------- >> using (System.Data.OleDb.OleDbConnection oledbConnect = new >> System.Data.OleDb.OleDbConnection(stConnectString)) >> { >> using (System.Data.OleDb.OleDbCommand oledbCmd = >> oledbConnect.CreateCommand()) >> { >> ... >> oledbCmd.ExecuteNonQuery(); >> //Retrieve the ID >> oledbCmd.CommandText = "Select @@Identity"; >> int iKeyID = (int)oledbCmd.ExecuteScalar(); >> stKeyID = iKeyID.ToString(); >> ----------------------------- >> >> What is the correct nomenclature for SQLite? >> _______________________________________________ >> 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users