OraFAQ Forum: Forms » How to control the opening form multiple times

Home » Developer & Programmer » Forms » How to control the opening form multiple times

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

How to control the opening form multiple times [message #200298]

Mon, 30 October 2006 04:55

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

Report message to a moderator

Re: How to control the opening form multiple times [message #200420 is a reply to message #200298]

Mon, 30 October 2006 19:34

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: How to control the opening form multiple times [message #200438 is a reply to message #200420]

Mon, 30 October 2006 22:44

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

Report message to a moderator

Re: How to control the opening form multiple times [message #200448 is a reply to message #200438]

Mon, 30 October 2006 23:42

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: How to control the opening form multiple times [message #301412 is a reply to message #200448]

Wed, 20 February 2008 08:47

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

Report message to a moderator

Re: How to control the opening form multiple times [message #301505 is a reply to message #301412]

Wed, 20 February 2008 21:24

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Go to the web page I listed, count to thirty, go to the BOTTOM of the page.

David

Report message to a moderator

Previous Topic:	Data Block DEFAULT_WHERE property issue
Next Topic:	Installation of Oracle Forms 6i on Windows XP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 09 23:30:19 CDT 2026