How can I get last autoincrement id after insert?

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Alexmv

How can I get last autoincrement id after insert?

Post by Alexmv » Mon 27 Mar 2006 09:28

MyQuery1.SQL.Add('insert ...');
MyQuery1.Execute;

???

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Mon 27 Mar 2006 09:55

Try this:

Code: Select all

n := MyQuery1.InsertId;

Alexmv

Post by Alexmv » Mon 27 Mar 2006 10:47

work!
thank you

Post Reply