sqlite3_last_insert_rowid

Nov 12, 2015 at 3:23 AM
Hi,

this is really great utility to use SQLite within Excel- VB.
I need to query the rowid after an INSERT statement on an active database connection but I didn't find anything like the sqlite3_last_insert_rowid function.
Is there any possibility to use it or a reliable workaround?
Coordinator
Nov 12, 2015 at 6:21 AM
That function is also available from SQL. You might like to try:
SELECT last_insert_rowid()
-Govert
Nov 12, 2015 at 8:08 PM
Yes, that's working for me.
Thanks a lot!