3
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by hfx642
0

I think you want to do following

1) press button on form1

2) in pl sql code of button, open form2 with some parameter

Steps for achiving this
1) in form two in object navigator mode you will file one node called PARAMTERS
add you paratmeter as many you want (for eg. p_1, p_2, p_3)

2) set form 2 in modal mode, so that after before closing form2 user can not access form1

3) in form one pl/sql code of button

DECLARE
		pl_id ParamList;
		pl_name VARCHAR2(10) := 'paramlist';
	  theformname  VARCHAR2(50);
	BEGIN
	  theformname := 'form2';
		pl_id := GET_PARAMETER_LIST(pl_name);
		IF ID_NULL(pl_id) THEN
			pl_id := CREATE_PARAMETER_LIST(pl_name);
		ELSE
			DELETE_PARAMETER(pl_id,'p_1');
			DELETE_PARAMETER(pl_id,'p_2');
			DELETE_PARAMETER(pl_id,'p_3');
		END IF;
		
 		Add_Parameter(pl_id,'p_1',TEXT_PARAMETER,'value1');
 		Add_Parameter(pl_id,'p_2',TEXT_PARAMETER,'value2');
 		Add_Parameter(pl_id,'p_3',TEXT_PARAMETER,'value3');
	 	
	  CALL_FORM(theformname,no_hide,do_replace,no_query_only,pl_id);
	END;
0

Whoa!! That's too much work!
Use Global Variables...

-- Set your Variable
:Global.Foobar = '42';

-- Call your Form
Call_Form ();

-- Test or reassign your Variable
:Block.Item = :Global.Foobar;

-- Destroy your Variable
Erase ('Global.Foobar');

-- Nice and simple!

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.