Row-trigger

[Quoted] [Quoted] trying to write a row-trigger that a particular field only changes depending on the content of another field in the same row. What am I doing wrong?

Thanks in advance,
Alex

CREATE OR REPLACE TRIGGER "DATA3"."TEST" BEFORE UPDATE OF     "PRUSERTEXT1"
    ON "DATA3"."MYTABLE" REFERENCING OLD AS OLDVAL NEW AS     NEWVAL
    FOR EACH ROW WHEN (IF :NEWVAL.USER == :OLDVAL.USER THEN     ELSE
       :NEWVAL.DEPARTMENT := :OLDVAL.DEPARTMENT;    END IF;) Received on Mon Mar 04 2002 - 18:44:28 CET