Subject Simple trigger question
Author Bob Jones
Anyone know the syntax for creating a trigger to update a date field with
the current date when a record is modified?

This is what I thought it should be, but I'm having trouble with the date
value. Also haven't been able to find it in the help file. Any assistance
would be appreciated.

SET TERM ^ ;
CREATE TRIGGER "SET_PAT_DATE" FOR "PATIENT"
BEFORE UPDATE
as begin
new.PA_UPDATED = date;
end
^