Re: saving username and sysdate on insert/update

Sybrand Bakker wrote
> if inserting then
> new.addte := sysdate;
> new.addusr := user;
> else
> new.upddte := sysdate;
> new.updusr := user;
> end if;

I am sure Sybrand knows, but just to be sure that Johnny gets there as well:

you should use :new instead of new.

Arjan. Received on Sat Apr 17 1999 - 15:16:44 CDT