How can i get id from recent append

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
vvitolo
Posts: 10
Joined: Fri 26 Aug 2005 21:45
Location: S/C de Tenerife

How can i get id from recent append

Post by vvitolo » Sat 27 Aug 2005 20:10

hi,
sorry for my poor english.
This is my Question:
How can i get the ID field (Autoincremental) from one table in case of new Append one register within Transaction, in order to use in other table (one field of another table), without committing the information, because we use the same thread and transaction for create the new register in both tables.

Thank you in advance and
best regards

Victor

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Mon 29 Aug 2005 08:10

After Post you can get value from TCustomMyDataSet.InsertId property

vvitolo
Posts: 10
Joined: Fri 26 Aug 2005 21:45
Location: S/C de Tenerife

Post by vvitolo » Tue 30 Aug 2005 23:24

OK. Resolved. Thank you.

Post Reply