Pete Finnigan's Oracle Security Forum


    
      
        Pete Finnigan's Oracle Security Forum
        (http://www.petefinnigan.com/forum/yabb/YaBB.cgi)
      

        Oracle General >> General Oracle questions >> Need to Quit  An App when I Exit  A Spec
        
(Message started by: Pete Finnigan on May 5^th, 2008, 3:27pm)

Title: Need to Quit An App when I Exit A Spec
Post by Pete Finnigan on May 5^th, 2008, 3:27pm

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..

Title: Re: Need to Quit An App when I Exit A Spec
Post by Pete Finnigan on May 9^th, 2008, 12:56am

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

Title: Re: Need to Quit An App when I Exit A Spec
Post by Pete Finnigan on May 26^th, 2008, 11:52pm

For anyone looking for a solution for this, this blog entry
http://talk2gerd.blogspot.com/2008/05/open-form-needs-intelligent-exit-form.html seems to have it covered.