|Subject||Re: [firebird-support] timestamp trigger?|
> Others have already helped you solve your problem. I thought I couldbtw, this is perfectly valid as well:
> 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
new.mytimestampfield = current_timestamp;
Database Workbench - development tool for Firebird and more!
Database development questions? Check the forum!