Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Exiting a 10g form without validation

Re: Exiting a 10g form without validation

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 16 Feb 2007 08:22:14 -0800
Message-ID: <1171642934.540795@bubbleator.drizzle.com>


papalphaus_at_yahoo.com wrote:

> On Feb 15, 7:42 pm, DA Morgan <damor..._at_psoug.org> wrote:
>> papalph..._at_yahoo.com wrote:

>>> I have a form that is trying to do validation checks when I click on
>>> the red X to exit the form. I have created a key_exit trigger at both
>>> the form level and block level with message statements in them so I
>>> will know when they are firing. None of my messages pop up, but one of
>>> my item validation failure messages (inside a when-validate-item
>>> trigger) pops up 4 times then the form asks me if I wish to close the
>>> form. This is a 10g form running on a 9i instance (soon to be upgraded
>>> to 10g). Is there not a way that I can just force the form to exit
>>> whenever the user clicks on the red X?
>> When you trap an error, anywhere, and don't re-raise it Oracle assumes
>> it has been dealt with. Does your WHEN-VALIDATE-ITEM trigger contain an
>> exception handler?
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org
> 
> Yes, it does have an exception which displays a message.  That is the
> problem, this messages pops up 4 times then the question 'Do you want
> to close this form' after the user clicks on the red X to exit the
> form.

If the WHEN-VALIDATE-ITEM trigger has an exception handler then the exception has been dealt with there and will not bubble up to the block or form level.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Feb 16 2007 - 10:22:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US