OraFAQ Forum: Forms » How To Navigate To A Particular Instance Of A Form Programmatically Which Is Opened Multiple times

Home » Developer & Programmer » Forms » How To Navigate To A Particular Instance Of A Form Programmatically Which Is Opened Multiple times (Oracle forms 10g)

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

How To Navigate To A Particular Instance Of A Form Programmatically Which Is Opened Multiple times [message #417976]

Wed, 12 August 2009 05:51

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

Report message to a moderator

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

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

Senior Member
Account Moderator

Click on it with your mouse.

David

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

basu2706
Messages: 10
Registered: August 2009

Junior Member

Hi Martin,

How do i store FORMMODULE datatype in DATABASE.

Thanks & Regards,
Basu

Report message to a moderator

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

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

Report message to a moderator