OraFAQ Forum: Forms » to pass value between forms

Home » Developer & Programmer » Forms » to pass value between forms

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

to pass value between forms [message #111999]

Tue, 22 March 2005 05:49

raje_here
Messages: 14
Registered: February 2005

Junior Member

how to pass value between forms...pls explain with an example..

Report message to a moderator

Re: to pass value between forms [message #112025 is a reply to message #111999]

Tue, 22 March 2005 08:40

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

hi,
You can pass values between forms using Parameters, Global Variable etc...
I'll use here Global Variable to explain you.
e.g:(I'm using emp and dept tables from the schema scott/tiger
Create a new form dept.
Create a new form emp.
Make a button on dept form.
Trigger :When-Button-Pressed
:GLOBAL.deptno := :DEPT.deptno; --Global var defined in formA
OPEN_FORM('emp');

Now in the emp form, create a trigger on emp block:
Trigger: When-New-Block-Instance
EXECUTE_QUERY;

Open the properties of emp block.
in the WHERE clause write this deptno = :GLOBAL.deptno
save both form and run the dept form.
Execute Query.
Click on the button in the dept for to open emp form.
When the emp form will open the query will be executed and the deptno 10 only will be populated in the form.
Note: Global variables exist throughout a forms session. Once defined in any form, we can use then anywhere in other forms.
Hopefully you can understand now how to pass values between the forms.
Regards

Report message to a moderator

Re: to pass value between forms [message #113090 is a reply to message #111999]

Wed, 30 March 2005 19:21

dal_hit
Messages: 16
Registered: March 2005
Location: New York

Junior Member

Hi Raj,

i know that how to pass value between forms in Forms 6i.

You have to create parameters in forms & pass that value while calling forms.

In forms help just type..." passing parameters between forms "

& follow the example..u will get solution..

Report message to a moderator

Previous Topic:	diff between object library and plsql library
Next Topic:	Running Oracle 6i Forms On Web

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 14:48:55 CDT 2024