Sorry ... I had not taken the time to read all the previous posts
about this matter, I just noticed them! Let me catch up on my
reading.

On 10/12/06, Fernando Salaices <fsalaices@...> wrote:
> Hello everyone.
>
> I need to have a timestamp that is updated every time a record is
> inserted or updated. I had asumed that just declaring the field as
> Timestamp this wold be acomplished but I was wrong. So a trigger
> (before update or insert) would be the next best thing. This is how I
> obtain the current date from firebird:
>
> select CURRENT_TIMESTAMP,
> from rdb$database;
>
> So I tried:
>
> select CURRENT_TIMESTAMP into NEW.MYTIMESTAMPFIELD,
> from rdb$database;
>
> did not work, so I tried:
>
> select CURRENT_TIMESTAMP into :NEW.MYTIMESTAMPFIELD,
> from rdb$database;
>
> Did not work either. So, can some one help me please? Is there another
> way to obtain an auto timestamp field?
>
> Can a BEFORE UPDATE and a BEFORE UPDATE OR INSERT coexist? Because my
> table already has a BEFORE INSERT trigger.
>
> --
>
> Saludos,
> Fernando Salaices.
>


--

Saludos,
Fernando Salaices.