Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!
Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.
Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!
When you'd like to retrieve the last ID SQLite3 used when you inserted a record that has an auto-increment ID field use the following when you're using Lazarus' standard SQLdb components:
- Do your usual AppenRecord on your TSQLQuery, and ApplyUpdates, and a Commit using TSQLTransaction.
- Check the GetInsertID property of your TSQLite3Connection which will give you the last ID you inserted.
For example:
SQLQuery1.appendrecord([ ... ]); // fill in your data here
SQLQuery1.ApplyUpdates;
SQLTransaction1.Commit;
SQLQuery1.Open;
ShowMessage(IntToStr(SQLite3Connection.GetInsertID));
