| Subject | Re: [firebird-support] Date stamp entry |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-03-15T03:14:58Z |
At 09:59 PM 14/03/2004 -0500, you wrote:
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
NEW.YOURDATESTAMP = CURRENT_TIMESTAMP;
END
/heLen
>Hello - newbie question ...CREATE TRIGGER BI_YOURTABLE FOR YOURTABLE
>
>How to : generate automatic datestamp entry on each new record in
>firebird ?
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
NEW.YOURDATESTAMP = CURRENT_TIMESTAMP;
END
/heLen