Auditing an Oracle database for security issues is very important. PeteFinnigan.com provides all of the information and tools that you will need Click here for details of PeteFinnigan.com Limited's detailed Oracle database security audit service Click here for details of PeteFinnigan.com Limited's Oracle Security Training Courses
Cookie Policy:We only use essential cookies on small sections of this website. For details see here.

Welcome, Guest. Please Login.
Nov 19th, 2017, 4:36am
News: Welcome to Pete Finnigan's Oracle security forum
Home | Help | Search | Members | Login
   Pete Finnigan's Oracle Security Forum
   Oracle General
   General Oracle questions
(Moderator: Pete Finnigan)
   Need to Quit  An App when I Exit  A Spec
« Previous topic | Next topic »
Pages: 1  Reply | Notify of replies | Send Topic | Print
   Author  Topic: Need to Quit  An App when I Exit  A Spec  (Read 2237 times)
dhar
PeteFinnigan.com Newbie
*



I love YaBB 1G - SP1!

   
View Profile |

Posts: 12
Need to Quit  An App when I Exit  A Spec
« on: May 5th, 2008, 3:27pm »
Quote | Modify

Hi,
 
I've built a forms application in Forms 6i. A parent (main) form exists.  Access to other forms are set in a hierarchy.ie form A ---> form B ---> form C ---> form D. I would like to close(quit) the entire application after exiting Form D, that is, I do not want to return to the previous forms  (C-->B-->A) before exiting.
 
 I've examined CLOSE_FORM and EXIT_FORM but I believe these are not suitable.  Is this a situation in which I MUST quit the Forms Runtime programmatically? I would prefer  to do this by using Forms/PLSQL....or any other method.....Is it possible to do this in Forms 6i ?   I would appreciate any suggestions on how to acheive this.....Thanks alot..
IP Logged
gamyers
PeteFinnigan.com Junior Member
**



I love YaBB 1G - SP1!

   
View Profile |

Posts: 80
Re: Need to Quit An App when I Exit A Spec
« Reply #1 on: May 9th, 2008, 12:56am »
Quote | Modify

I think the only way to do it is set a global variable (eg in a library used by all forms or as a SYS_CONTEXT in the database) and check that as focus returns to each form (when-form-activated trigger or something lkie that).
So as 'D' quits, control goes to 'C' which sees the variable has been set so closes, which passes control to 'B' etc.
 
Haven't used Forms for a few years, so my memory is foggy on the details (which triggers can do an exit for example), but I remember using the general principle.
The Forms forum on OTN or quest_pipelines http://pipetalk.quest-pipelines.com/default.asp?boardid=plsql may give more details
IP Logged
gamyers
PeteFinnigan.com Junior Member
**



I love YaBB 1G - SP1!

   
View Profile |

Posts: 80
Re: Need to Quit An App when I Exit A Spec
« Reply #2 on: May 26th, 2008, 11:52pm »
Quote | Modify

For anyone looking for a solution for this, this blog entry
http://talk2gerd.blogspot.com/2008/05/open-form-needs-intelligent-exit-f orm.html seems to have it covered.
IP Logged
Pages: 1  Reply | Notify of replies | Send Topic | Print

« Previous topic | Next topic »

Powered by YaBB 1 Gold - SP 1.4!
Forum software copyright 2000-2004 Yet another Bulletin Board