Trigger Code Changing After Execution

Hi,
Does any one know why when I execute the below trigger code in SQL Worksheet that it has changed when I view it in Schema Manager (Oracle 7.3.3 on NT4 sp6)

Code:

CREATE OR REPLACE TRIGGER trg_AgentAddressB BEFORE INSERT OR UPDATE ON tbl_AgentAddress for each row Begin
:new.ModifiedDateTime :=SYSDATE;
:new.ModifiedByUserId :=USER;

end trg_AgentAddressB;

Changes to:

CREATE OR REPLACE TRIGGER trg_AgentAddressB BEFORE INSERT OR UPDATE OF ModifiedDateTime, ModifiedByUserId ON tbl_AgentAddress for each row
Begin
:new.ModifiedDateTime :=SYSDATE;
:new.ModifiedByUserId :=USER;

end trg_AgentAddressB;

I want it to catch all Inserts and Updates on the Table.

Thanks Gary. Received on Fri Jan 21 2000 - 09:27:53 CST