Re: Row-trigger

do you need to use colons in the WHEN clause? I thought it worked something like this:
...
FOR EACH ROW WHEN (IF NEWVAL.USER = OLDVAL.USER THEN NULL) ...

(or maybe the colon does not matter either way?)

"Gerard H. Pille" wrote:
>
> 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!)
Received on Mon Mar 04 2002 - 20:53:49 CET