On 6 Feb 2017, at 1:30pm, Clyde Eisenbeis <cte...@gmail.com> wrote: > 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().
last_insert_row() is an SQL variable. In whatever API you’re using, do whatever you’d do to execute a SELECT command but instead of selecting data from a table do SELECT last_insert_row() instead. Please note that the standard SQLite API is C code. If you’re not programming in C you have to tell us what you are programming in, or we have no clue how your programming language accesses SQLite databases. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users