To whom it may concern,
I know you have a property TLiteSQL.LastInsertId but I need to get the last inserted id from the TLiteConnection.
Can you please make the SQLite function last_insert_rowid() available in the TLiteConnection class
Best Regards
Eric
last_insert_rowid
Re: last_insert_rowid
To implement the behavior you describe, just use the following query:
Code: Select all
SELECT last_insert_rowid ()
Re: last_insert_rowid
We were glad to help you. Please don't hesitate to contact us with questions concerning LiteDAC usage.