Page 1 of 1

Getting an autoupded value

Posted: 15.10.2009, 03:11
by -Cannon_Fodder-
I've used a ZConnection and a ZQuery to add records to a table, but now I need to do somthing different.

I need to add a record to a table with an autoupdate field and get the aupdated value from the newly added record. What Zeos components to I need to add and how to I connect them to do this?

I'm a noob to this.

Posted: 16.10.2009, 18:51
by mdaems
Hi,

This depends a little on the database and the kind of autoupdated field you use.
For an autoincrement with mysql you can just append a record by providing all other fields. After the post (+ ApplyUpdates when using cachedUpdates) the autoinc value will be available in the dataset.

Mark