How automaticaly retrieve autoincrement field
Posted: 23.07.2007, 12:41
Hi.
I use MySQL 4.1 and ZeosLib 6.5.1.
In TZQuery after inert null value into autoincrement field, DataSet is automatically refreshed with last_insert_id and this is great. But I have problem when use TZUpdateSQL with TZQuery. Autoincremented field is not automatically refreshing and I have problem with for example delete record. I dont want refresh each time all query after insert. What is workaround?
Thanks
Przemm07
I use MySQL 4.1 and ZeosLib 6.5.1.
In TZQuery after inert null value into autoincrement field, DataSet is automatically refreshed with last_insert_id and this is great. But I have problem when use TZUpdateSQL with TZQuery. Autoincremented field is not automatically refreshing and I have problem with for example delete record. I dont want refresh each time all query after insert. What is workaround?
Thanks
Przemm07