I'm writing WPF / C# code. This is part of a function that is called whenever the user enters data that is saved. The primary key is used whenever the user changes that record ... to ensure the correct data is changed.
On Mon, Feb 6, 2017 at 10:11 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
