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
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>



--

Saludos,
Fernando Salaices.


[Non-text portions of this message have been removed]