Home » Developer & Programmer » Forms » How to control the opening form multiple times
How to control the opening form multiple times [message #200298] Mon, 30 October 2006 04:55 Go to next message
kbhujendra@rediffmail.com
Messages: 26
Registered: June 2006
Location: Hyderabad,India
Junior Member

Greetings to all,

I used Open_Form to open the form in my 'Menu.mmb'.
My Question is:
How we control the opening of a form from multiple times?
Ex:
In my menu.mmb I used OPEN_FORM.If we open the form,which was already opened ,I want to stop the form to open. How to do this?

I used find_form and id_null Built-ins but no joy.

Thanks,
Bhujendra
Re: How to control the opening form multiple times [message #200420 is a reply to message #200298] Mon, 30 October 2006 19:34 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Find_Form and id_null should have solved your problem. What version of Forms are you using? Please post your code.

David
Re: How to control the opening form multiple times [message #200438 is a reply to message #200420] Mon, 30 October 2006 22:44 Go to previous messageGo to next message
kbhujendra@rediffmail.com
Messages: 26
Registered: June 2006
Location: Hyderabad,India
Junior Member

David,

I am using forms6i and my code is
DECLARE 
      rg_name VARCHAR2(40) := 'C:\INH\EMPDETAILS1.fmx';
  BEGIN 
      If ID_NULL(FIND_FORM(rg_name)) 
       Then
         OPEN_FORM(rg_name);
      Else
         GO_FORM(rg_name);
      End If; 
  END;

If any thing need to be changes please advice me


Thanks,
Bhujendra
Re: How to control the opening form multiple times [message #200448 is a reply to message #200438] Mon, 30 October 2006 23:42 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
If you google 'go_form' you will find entries like http://www.experts-exchange.com/Databases/Oracle/Q_20171540.html

What they say is that 'find_form' looks in the file system, but the 'go_form' looks in the list of running code.

Either use the 'find_form' id for both calls, or use the module name ('EMPDETAILS1' - no directory path or 'fmx' extension) for both calls, or a mix but making sure that the 'go_form' only contains the module name.

David
Re: How to control the opening form multiple times [message #301412 is a reply to message #200448] Wed, 20 February 2008 08:47 Go to previous messageGo to next message
dillango
Messages: 145
Registered: January 2008
Senior Member
Mr.David,

I could not use your link (not free it seems) to find the solution. I still looking for right solution. Hope you will guide me something.

Regards, ILANGO
Re: How to control the opening form multiple times [message #301505 is a reply to message #301412] Wed, 20 February 2008 21:24 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Go to the web page I listed, count to thirty, go to the BOTTOM of the page.

David
Previous Topic: Data Block DEFAULT_WHERE property issue
Next Topic: FRM-99999: Error 10905
Goto Forum:
  


Current Time: Sun Dec 04 15:02:44 CST 2016

Total time taken to generate the page: 0.25300 seconds