OraFAQ Forum: Forms » Passing info. thru forms

Home » Developer & Programmer » Forms » Passing info. thru forms (oracle form10g)

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

Passing info. thru forms [message #555717]

Sun, 27 May 2012 12:09

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

Hi i have 2 forms,
FormA and Formb.

My Forma.fmx -->

Id :
Name :
sal:

Fomrb.fmx :

Id :
Name:
Sal:
Grade:
Postion:

Forma.fmx conatin one button submit , after i pressing tis button , all information fiiled in forma.fmz is paddes thru fromb.fmx

Then how can i do it.

I know by using call_form('formb.fmx'), i can open formb...but how can i pass the information.

Please this is one of question asked me on interview.

Report message to a moderator

Re: Passing info. thru forms [message #555718 is a reply to message #555717]

Sun, 27 May 2012 13:32

cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester

Senior Member

By using parameters - read up on them in form builder help

Report message to a moderator

Re: Passing info. thru forms [message #555719 is a reply to message #555718]

Sun, 27 May 2012 14:42

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Alternatively, you could use global variables (which are not as good as parameters Cookiemonster suggested).

Or, you could even COMMIT changes in Form_A, pass only ID (as a parameter) to Form_B, in PRE-QUERY trigger set ONETIME_WHERE (or DEFAULT_WHERE) block property to

:form_b_block.id := :parameter.id;

and EXECUTE_QUERY which would - from a table - fetch data stored by the Form_A.

Report message to a moderator

Re: Passing info. thru forms [message #555750 is a reply to message #555717]

Mon, 28 May 2012 04:36

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

Thanks Cookiemaster & littlefoot,

1) I have another question related to this, if suppose i called form2 by using form1. And suppose form2 have any error , doesn it affect to form1 also.

2) and if form2 affected any error then how can i save form1 data. means i want to ask how i protect my form1 data, if anything happens with form2.

Report message to a moderator

Re: Passing info. thru forms [message #555754 is a reply to message #555750]

Mon, 28 May 2012 06:19

cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester

Senior Member

Errors in form 2 don't affect form 1, so there's nothing to prevent you saving data in form 1.

Report message to a moderator

Re: Passing info. thru forms [message #555760 is a reply to message #555754]

Mon, 28 May 2012 06:37

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

Thanks sir,...

sir it reason is that form2 is open in diff. session that why it doesnt affect from form1

Report message to a moderator

Re: Passing info. thru forms [message #555762 is a reply to message #555760]

Mon, 28 May 2012 06:42

cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester

Senior Member

If it's a different session then it can't affect form 1.
If it's the same session (and it can be - depends what command you use to call form 2) then it shouldn't affect form 1 because it creates a savepoint when it starts form 2 and an error will cause a rollback to that savepoint.

Report message to a moderator

Re: Passing info. thru forms [message #556222 is a reply to message #555762]

Fri, 01 June 2012 00:48

swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai

Senior Member

cookiemonster wrote on Mon, 28 May 2012 17:12

If it's the same session (and it can be - depends what command you use to call form 2)

Do You want to say,it possible 2 form open in same session...If Yes, What Command is to use ???

Report message to a moderator

Re: Passing info. thru forms [message #556272 is a reply to message #556222]

Fri, 01 June 2012 06:10

cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester

Senior Member

Read up on call_form, open_form and new_form in form builder help.

Report message to a moderator

Previous Topic:	COMMENT BUTTON Set_ICO_Property
Next Topic:	clear block

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 22:03:08 CDT 2024