TZUPDATESQL and autoincrement fields

[marcocot]

Hello,
I have a simple table with an autoincrement field. I have dropped a TZQUERY and aTZUpdateSQL.
Just to test I filled Zquery.SQL property with
SELECT * FROM atable
and filled the sql properties of the TZUpdateSQL component with the proper statentemnts.

I tryied working in autocommit mode:

Zquery1.Append;
ZQuery1.Post;

But I don't get the autoincrement field incremented. If I delete the TZUpdateSQL component it works fine. How can I make autoincrement field s work with TZUpdateSQL?

Thanks

Marco

[mdaems]

marcocot,
Have a look here : http://zeos.firmos.at/viewtopic.php?t=1257

It's a firebird example, but I remember I've written some mysql related stuff as well.

Mark