To clarify further, the SQLite function is attached. Retrieving the primary key is commented (used by System.Data.OleDb function).
On Sun, Feb 5, 2017 at 10:40 AM, J Decker <d3c...@gmail.com> wrote: > 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users