Re: Forms question

First add the column ModifiedBy to the table in the database. Then, write a before insert or update trigger on the table using:

create or replace trigger t_upd
before update or insert on t
for each row
begin

   :new.ModifiedBy := user;
end;
/

HTH Yosi

Steve Macmillan wrote:

> I've created a form and I want to add a "Modified By" field so when
> the database is updated the person who modified it (or their login)
> will automatically appear in that field.
>
> Thanks !
Received on Fri Oct 22 1999 - 11:56:22 CDT