Thanks! I can always count on you guys with a helpful and prompt response.

Bob

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Monday, October 22, 2001 7:19 AM
To: IBObjects@yahoogroups.com; IBObjects@yahoogroups.com
Subject: Re: [IBO] Simple trigger question


At 06:58 AM 22-10-01 -0400, Bob Jones wrote:

>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
> ^

Dialect 3:
new.PA_UPDATED = CURRENT_DATE; /*if the column is a dialect 3 DATE type
*/
CURRENT_TIMESTAMP /* TIMESTAMP type */

Others:
Dialect 1:
new.PA_UPDATED = cast('Now' as date); (or cast('today' as date))

IB 5 and below:

new.PA_UPDATED = 'Now'; (or 'Today')

H.


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________


___________________________________________________________________________
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 http://docs.yahoo.com/info/terms/