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 <[email protected]> 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 <[email protected]> wrote: > >> >> On 5 Feb 2017, at 1:26pm, Clyde Eisenbeis <[email protected]> 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 >> [email protected] >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
