I'm creating a simple form to update a specific record. I have an update transaction and a form built using the Update Record Form Wizard. Now I want to update a DATETIME field everytime the update transaction runs.

I know this is a simple question. I just don't see where to add the now() function to the update query.

Stuart

Stuart,

In the Wizard, add {NOW_DT} as the default value for that timestamp field. You can make the timestamp field hidden and add that as the default value. {NOW_DT} is ADDT markup for now().

Another option is to make a timestamp field in your database table and set it to do a current timestamp on update. This will add a MySQL timestamp to a row's timestamp field everytime the row is updated.

Shane

Thanks! That's just what I needed. I wasn't even thinking of the "TIMESTAMP" option.

Stuart

hello you could simply try this..
add a new field/column to ur database row called AutoRowDate and its type as TIMESTAMP.

ALTER TABLE `MyGoodTablesNameHere`
ADD `AutoRowDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Security TimeStamp';