Select last insert row id

[LemonParty]

I have this code:

Code: Pascal  [Select][+][-]

1. function TdmSQLite.Insert(Path: String; Archive: TByteDynArray): SizeInt;
2. begin
3.   Result:= -1;
4.   Query.Close;
5.   Query.SQL.Text:= 'INSERT INTO Backup(Path, Archive) VALUES (:Path, :Archive)';
6.   Query.ParamByName('Path').AsString:= Path;
7.   Query.ParamByName('Archive').AsBlob:= Archive;
8.   Query.ExecSQL;
9.   Tran.Commit;
10.  
11.   Query.SQL.Text:= 'SELECT last_insert_rowid()';
12.   Query.Open;
13.   Result:= Query.Fields[0].AsInteger;
14. end;

And I have a doubt. Should I put Transaction.Commit after or before "SELECT last_insert_rowid()"?

[Sieben]

Before - insert action has to be finalized to produce a valid ID. And you might as well use TSQLite3Connection.GetInsertID instead of your Query.

[LemonParty]

Thank you.

[Zvoni]

Or implement a Callback like described here: http://sqlite.org/c3ref/update_hook.html
The it's basically like an Event