Dear all,

I have a table T1:
ID integer, (PK, autogen by a trigger)
NAME VARCHAR(10),
LAST_UPDATE TIMESTAMP

I have a IB_Query:
SQL : 'select id, name, last_update from T1'
Update SQL : 'update T1 set id = :id, name = :name, last_update
= :last_update where id = :id'
"ID" and "Last_update" is set to NOEDIT

This Query is bind to a Grid for Edit.

Now, how can I set the "last_update" field to NOW() on every record
update?
I am using Firebird on Linux, there is no UDF like NOW(), that means
I cannot do it in a trigger.

Thanks in advance.


Rgds,
Michael