Home » Developer & Programmer » Forms » Conditional exit on PRE_FORM Trigger (Forms 6i)
Conditional exit on PRE_FORM Trigger [message #342777] Mon, 25 August 2008 01:23 Go to next message
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
Re: Conditional exit on PRE_FORM Trigger [message #342916 is a reply to message #342777] Mon, 25 August 2008 08:53 Go to previous messageGo to next message
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.
Re: Conditional exit on PRE_FORM Trigger [message #343019 is a reply to message #342777] Mon, 25 August 2008 22:37 Go to previous messageGo to next message
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
Re: Conditional exit on PRE_FORM Trigger [message #343140 is a reply to message #343019] Tue, 26 August 2008 07:37 Go to previous messageGo to next message
szogu
Messages: 21
Registered: July 2008
Junior Member
It would work for both, client-server deployment and three tier deployment.
Re: Conditional exit on PRE_FORM Trigger [message #344689 is a reply to message #343140] Mon, 01 September 2008 00:59 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Use the When-New-Form-Instance trigger.

David
Re: Conditional exit on PRE_FORM Trigger [message #344856 is a reply to message #344689] Mon, 01 September 2008 07:40 Go to previous message
didiera
Messages: 134
Registered: August 2007
Location: Mauritius
Senior Member
Hi all,

thanks David but I went already for the raise form_trigger_failure and it's fine for me.

cheers everyone,
Didier
Previous Topic: Oracle FORMS
Next Topic: hh:mm:ss with date
Goto Forum:
  


Current Time: Tue Dec 06 08:08:29 CST 2016

Total time taken to generate the page: 0.12386 seconds