SQL*Froms v3 - Trigger Failure
From: Mike Oswald <moswald_at_cwis.unomaha.edu>
Date: Fri, 14 May 1993 21:51:29 GMT
Message-ID: <1993May14.215129.9185_at_news.unomaha.edu>
Date: Fri, 14 May 1993 21:51:29 GMT
Message-ID: <1993May14.215129.9185_at_news.unomaha.edu>
In v2.3 you could write an trigger step like this:
#exemacro case :<field1> is
Rather simple but how does ENDTRIG; work in v3? I've tried using the
RAISE FORM_TRIGGER_FAILURE but I must be missing something.
All I want to do is to do some checking and in a PRE-INSERT or PRE-UPDATE
when '' then message <...>; ENDTRIG; -or- ENDTRIG FAIL;
when others then <..blah..> ;
end case;