If your DB is Dialect 3, you can use

new."posting_date" = current_date;

Ernesto Cullen

----- Original Message -----
From: "jerrypark12357" <jerry_park@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, July 10, 2002 7:14 PM
Subject: [ib-support] Trigger to place date.


> I'm fairly new to Firebird/Interbase and am in the process of
> designing a database. I couldn't find in the documentation a method of
> creating a trigger to place the current date in a field. I understand
> how to create triggers, just don't know how to do this particular one.
>
> NEW."posting_date" = [what];
>
> thanks
>
>