Home » Developer & Programmer » Forms » How To Navigate To A Particular Instance Of A Form Programmatically Which Is Opened Multiple times (Oracle forms 10g)
icon5.gif  How To Navigate To A Particular Instance Of A Form Programmatically Which Is Opened Multiple times [message #417976] Wed, 12 August 2009 05:51 Go to next message
basu2706
Messages: 10
Registered: August 2009
Junior Member
Hi,

In a multi-form application i have opened a form multiple times, how can i go to a particular instance of that opened form programatically.
Ex: FormA is opened twice using OPEN_FORM('formA');
how can we go_form(<first opened form>);
Regards,
Basu
Re: How To Navigate To A Particular Instance Of A Form Programmatically Which Is Opened Multiple tim [message #418073 is a reply to message #417976] Wed, 12 August 2009 20:45 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Click on it with your mouse.

David
Re: How To Navigate To A Particular Instance Of A Form Programmatically Which Is Opened Multiple tim [message #418075 is a reply to message #418073] Wed, 12 August 2009 20:53 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
<<Note to self: Be less sarcastic!! I really need a holiday.>>

Use the 'find_form' command in the new form and store the information somewhere in the database - table or package specification. When you want to go to the first form retrieve the earliest entry for that form and then do your 'go_form'.

David
Re: How To Navigate To A Particular Instance Of A Form Programmatically Which Is Opened Multiple tim [message #418092 is a reply to message #418075] Wed, 12 August 2009 22:41 Go to previous messageGo to next message
basu2706
Messages: 10
Registered: August 2009
Junior Member
Hi Martin,

Thanks for the reply, actually i was trying with the similar method but its not working.

Here is the sample code and error am facing, for your reference:

DECLARE
FORM_ID FORMMODULE;
STORE_ID PLS_INTEGER;
BEGIN

FORM_ID := FIND_FORM('BROWSER');
STORE_ID := FORM_ID.ID;
-- STORE IT IN DB (STORE_ID)
END;

--CALL IT USING STORE_ID
GO_FORM(STORE_ID);

But am getting error as
Argument 1 to GO_FORM cannot be null

cause: its reading it as form-name not as the form id.

Please let me know how can i resolve this issue.

Thanks and Regards,
Basu
Re: How To Navigate To A Particular Instance Of A Form Programmatically Which Is Opened Multiple tim [message #418112 is a reply to message #418092] Thu, 13 August 2009 01:11 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Why do you have different datatypes on 'form_id' and 'store_id'? They should both be 'formmodule'. Look at the various code samples that use 'find_form'.

David
Re: How To Navigate To A Particular Instance Of A Form Programmatically Which Is Opened Multiple tim [message #418115 is a reply to message #418112] Thu, 13 August 2009 01:22 Go to previous messageGo to next message
basu2706
Messages: 10
Registered: August 2009
Junior Member
Hi Martin,

How do i store FORMMODULE datatype in DATABASE.

Thanks & Regards,
Basu
Re: How To Navigate To A Particular Instance Of A Form Programmatically Which Is Opened Multiple tim [message #418117 is a reply to message #418115] Thu, 13 August 2009 01:31 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
My name is 'David'. It is the name that I place at the end of all of my posts.

I repeat: "Look at the various code samples that use 'find_form'."

David
Re: How To Navigate To A Particular Instance Of A Form Programmatically Which Is Opened Multiple tim [message #418120 is a reply to message #418117] Thu, 13 August 2009 01:34 Go to previous messageGo to next message
basu2706
Messages: 10
Registered: August 2009
Junior Member
Ok David.
Re: How To Navigate To A Particular Instance Of A Form Programmatically Which Is Opened Multiple tim [message #418182 is a reply to message #418120] Thu, 13 August 2009 05:07 Go to previous message
basu2706
Messages: 10
Registered: August 2009
Junior Member
Thanks David,

I got it using SHARE_LBRARY_DATA in OPEN_FORM.

Basu,
Previous Topic: Guidance for Beginners?
Next Topic: change password if new user
Goto Forum:
  


Current Time: Fri Dec 09 17:11:26 CST 2016

Total time taken to generate the page: 0.23641 seconds