new.PA_UPDATED = 'now';

as long as PA_UPDATED is type DATE

Artur

----- Original Message -----
From: Bob Jones
To: IBObjects@yahoogroups.com
Sent: Monday, October 22, 2001 11:58 AM
Subject: [IBO] Simple trigger question


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
^


Yahoo! Groups Sponsor



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]