Thanks He;en ..
Does this datestamp automatically update itself if the record is
modified...?


Helen Borrie wrote:

> At 09:59 PM 14/03/2004 -0500, you wrote:
> >Hello - newbie question ...
> >
> >How to : generate automatic datestamp entry on each new record in
> >firebird ?
>
> CREATE TRIGGER BI_YOURTABLE FOR YOURTABLE
> ACTIVE BEFORE INSERT POSITION 0
> AS
> BEGIN
> NEW.YOURDATESTAMP = CURRENT_TIMESTAMP;
> END
>
>
> /heLen
>
>
>
> ------------------------------------------------------------------------
> *Yahoo! Groups Links*
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>