Home » Developer & Programmer » Forms » Forms Parameter (ORacle Forms 4.5)
Forms Parameter [message #297204] Wed, 30 January 2008 11:24 Go to next message
mdamjad
Messages: 45
Registered: May 2005
Member
I am Want pass parameter to Form . Please help . I have created following Forms

Form-1(Calling Form)
Trigger When-Item-Instance

declare

param_list_id ParamList;
begin
select ccode,name into :product.ccode, :product.name from company where ccode=:product.ccode;

param_list_id := GET_PARAMETER_LIST('TEMP_data');

IF NOT ID_NULL(param_list_id) THEN
DESTROY_PARAMETER_LIST(param_list_id);
END IF;
param_list_id := CREATE_PARAMETER_LIST('TEMP_data');

ADD_PARAMETER(param_list_id, 'name', TEXT_PARAMETER,:product.name);

call_FORM('d:\test\main.fmx', HIDE, NO_REPLACE, NO_QUERY_ONLY, param_list_id);

END;

-------------------------

Form-2 (Called Form)
Trigger : When-New-Form-Instance

max_win;
:name:=:parameter.name;

-------------------------------

Form-2 (called form) has a menu .
Value is passed from Form-1 to Form-2 .
But If further try to pass parameter to another form(Form-3) from Menu on Form-2 . The value doest not pass.

Code on Menu Item is

declare

param_list_id ParamList;
begin


param_list_id := GET_PARAMETER_LIST('TEMP_data');

IF NOT ID_NULL(param_list_id) THEN
DESTROY_PARAMETER_LIST(param_list_id);
END IF;
param_list_id := CREATE_PARAMETER_LIST('TEMP_data');

ADD_PARAMETER(param_list_id, 'name', TEXT_PARAMETER,:name);

call_FORM('d:\test\prod.fmx', HIDE, NO_REPLACE, NO_QUERY_ONLY ,param_list_id);

END;
Re: Forms Parameter [message #297219 is a reply to message #297204] Wed, 30 January 2008 13:04 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Not exactly the answer to your question, but - did you consider using a global variable instead?
Re: Forms Parameter [message #297279 is a reply to message #297204] Wed, 30 January 2008 23:52 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
What is ':name'? Where is the 'block' descriptor?

Is the block that contains 'name' a control block or one on which you perform a query?

David
Previous Topic: Progress Bar
Next Topic: Global Variables
Goto Forum:
  


Current Time: Mon Mar 10 20:12:20 CDT 2025