Subject | Simple trigger question |
---|---|
Author | Bob Jones |
Post date | 2001-10-22T10:58:34Z |
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
^
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
^