>Is it possible to use the update trigger for a table to update fields in the table that has fired the trigger.
>
>What I would like to achieve is to have the Update Trigger set a date and time field with the date & time that the record was updated. If I try to do this using the following procedure I get an error message "cannot update the cursor".
>
>PROCEDURE _TESTTABLEUPDATE
>IF _TRIGGERLEVEL > 1
> RETURN .t.
>ELSE
> REPLACE DATE WITH DATE() IN TESTTABLE
> REPLACE TIME WITH TIME() IN TESTTABLE
>ENDIF
>RETURN .t.
>
>
>Any advice gratefully received,
>
>TIA
>
>Andy
Steven's right. But you can use the validation rule to modify fields. This is where I put my timestamp logic.
Erik Moore
Clientelligence