|Subject||Re: [firebird-support] timestamp trigger?|
ok, thank you very much for all your answers. It's working now.
On 10/12/06, Martijn Tonies <m.tonies@...> wrote:
> > Others have already helped you solve your problem. I thought I could
> > just say why your original statement didn't work (or at least one of the
> > reasons, I haven't tested anything).
> > > select CURRENT_TIMESTAMP into NEW.MYTIMESTAMPFIELD,
> > > from rdb$database;
> > The syntax isn't
> > SELECT ... INTO ... FROM
> > Rather, it is
> > SELECT ... FROM ... INTO
> > So, I'd expect
> > select CURRENT_TIMESTAMP from rdb$database
> > into NEW.MYTIMESTAMPFIELD
> btw, this is perfectly valid as well:
> new.mytimestampfield = current_timestamp;
> Martijn Tonies
> Database Workbench - development tool for Firebird and more!
> Upscene Productions
> My thoughts:
> Database development questions? Check the forum!
[Non-text portions of this message have been removed]