http://data.sqlite.org/c3ref/last_insert_rowid.html
there is an api call to get it; or you can use select and get it.... the .net library has it as a connection property LastInsertRowId https://www.crestron.com/reference/simpl_sharp/html/P_Crestron_SimplSharp_SQLite_SQLiteConnection_LastInsertRowId.htm On Sun, Feb 5, 2017 at 5:54 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 5 Feb 2017, at 1:26pm, Clyde Eisenbeis <cte...@gmail.com> wrote: > > > The compiler complains about "SELECT last_insert_rowid()" ... which > > appears to be limited to SQLite3. > > The compiler should never have got that string. The string is executed > when the program is already compiled, just like any other SELECT command. > > Find some context where you can execute any other SELECT command, and use > "last_insert_rowid()" as a column name. > > 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