|
|
|
|
| Re: HOW I CAN ASSIGN PARAMETER VALUE TO TEXT ITEM (HELP) [message #252549 is a reply to message #252525] |
Thu, 19 July 2007 02:52   |
hussienburhan
Messages: 28
Registered: July 2007
|
Junior Member |
|
|
thank u alot
i have this code to call form and sending to it parameter
declare
L_pl_id paramlist;
L_called_program VARCHAR2(20) := NULL;
BEGIN
--P_destroy_parameter_list('visib_testF');
L_pl_id := Create_Parameter_List('visib_testF');
Add_Parameter(L_pl_id, 'REFCOODE', TEXT_PARAMETER, :visib_market.REFCODE);
L_called_program := 'visib_rep';
Open_Form (L_called_program,
ACTIVATE,
SESSION,
L_pl_id);
EXCEPTION
when FORM_TRIGGER_FAILURE then
raise;
when OTHERS then
--emessage(SQLERRM);
raise FORM_TRIGGER_FAILURE;
END;
i defiend parameter in the second form called refcoode
and i want send from the first form to second form value that in my tetx item called refcofe
how i can send value from one textitem in the main form to put in another textitem in the second form
thaank u
|
|
|
|
|
|
| Re: HOW I CAN ASSIGN PARAMETER VALUE TO TEXT ITEM (HELP) [message #252560 is a reply to message #252549] |
Thu, 19 July 2007 03:05 |
bahubcd
Messages: 40
Registered: July 2007
Location: Bangalore
|
Member |
|
|
Step 1>(To be coded in main form or calling form)
Populate the parameter list
Add_Parameter(L_pl_id, 'REFCOODE', TEXT_PARAMETER, :visib_market.REFCODE);
Step 2>>(To be coded in sub form or called form)
:DATA_BLOCK.TEXT_ITEM := :PARAMETER.REFCOODE;
-------------------------------------------------
Its like
temp=a
b=temp
So effectively b=a
temp is your parameter of the sub form thats it.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
