At 10:19 PM 14/03/2004 -0500, you wrote:

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

Only if you add a Before Update trigger as well.

heLen

>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/>.
> >
> >
>
>
>
>
>Yahoo! Groups Links
>
>
>
>