Re: Forms 5.0 Error Trapping

From: Harold Peske <hpeske_at_telusplanet.net>
Date: Sun, 25 Apr 1999 22:47:47 GMT
Message-ID: <nYMU2.10980$5p5.9733_at_news1.telusplanet.net>


Ken,

You can in fact use the ON-ERROR trigger to capture errors. Another alternative is to add an EXCEPTION clause at the end of any trigger at which point you can trap whatever errors you choose. Remember, if you add an EXCEPTION clause, you must start with BEGIN.

Hope this is helpful.......

HAROLD Ken Halsted wrote in message <924791528.314.69_at_news.remarQ.com>...
>I was wondering how is the correct way to Trap errors in Forms 5. I know
>you can use an ON-ERROR trigger on the block involved, but in the trigger
>itself, how do you trap specific FRM-XXXX error messages.
>
>I want to print a nice message box on the screen with a user-informative
>message instead of just seeing the normal Forms error. Also, how do I get
a
>message box to appear. Usually I do something like the following:
>
>IF ERROR_NUMBER = (WHATEVER) THEN
> MESSAGE('TESTING'); MESSAGE(' '); SYNCHRONIZE;
> RAISE FORM_TRIGGER_FAILURE;
>
>Is there a better way?
>
>Ken.
>
>--
>_________________
>Kenneth W. Halsted
>Mountaire Corporation
>ph: (501) 399-8812
>url: http://www.mountaire.com
>email: kenman_at_mail.snider.net
>
>
>
Received on Mon Apr 26 1999 - 00:47:47 CEST

Original text of this message