OraFAQ Forum: Forms » Conditional exit on PRE

Home » Developer & Programmer » Forms » Conditional exit on PRE_FORM Trigger (Forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Conditional exit on PRE_FORM Trigger [message #342777]

Mon, 25 August 2008 01:23

didiera
Messages: 134
Registered: August 2007
Location: Mauritius

Senior Member

Hi all,

I have to implement a piece of logic here to close a form based on some conditions being met or not. I initiate the test from within a PRE_FORM trigger and I would wish the Form to exit if some condition is met. My problem is that PRE_FORM prevents the use of EXIT_FORM with whatever predicates. Well the thing is that my forms actually exists but not graciously.

The Plot: The PRE_FORM trigger calls a procedure that fires a custom error code (eg. 20997) at database level. My PRE_FORM catches this and displays some error message to explain the user what's happening and should exit afterwards.

Question: Is there an alternative to implement this while still using PRE_FORM trigger?

thanks

Report message to a moderator

Re: Conditional exit on PRE_FORM Trigger [message #342916 is a reply to message #342777]

Mon, 25 August 2008 08:53

szogu
Messages: 21
Registered: July 2008

Junior Member

Your asnwer is in Pre-Form Trigger description in on-line help of oracle forms.
Please read topic On Failure. (I Hope you know how to make a Forms triger Fail.)

Regards.

Report message to a moderator

Re: Conditional exit on PRE_FORM Trigger [message #343019 is a reply to message #342777]

Mon, 25 August 2008 22:37

didiera
Messages: 134
Registered: August 2007
Location: Mauritius

Senior Member

Thanks,

I'll try this. Of course I do know how to do it with a raise form_trigger_failure. Will it also work for browser-based sessions?

regards,
Didier

Report message to a moderator