Page 1 of 1

last_insert_rowid

Posted: Tue 10 Oct 2017 01:38
by egrobler
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

Re: last_insert_rowid

Posted: Wed 11 Oct 2017 11:41
by MaximG
To implement the behavior you describe, just use the following query:

Code: Select all

SELECT last_insert_rowid ()

Re: last_insert_rowid

Posted: Wed 11 Oct 2017 12:12
by egrobler
Works perfectly, thanks

Re: last_insert_rowid

Posted: Wed 11 Oct 2017 12:24
by MaximG
We were glad to help you. Please don't hesitate to contact us with questions concerning LiteDAC usage.