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
