Re: Row-trigger

News via skynet wrote:
>
> Hi,
>
> 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;)
???
THEN
 NULL;
ELSE

-- 

Gerard H. Pille

(The Beatles Reunion is neigh!)