Home » Developer & Programmer » Forms » HOW I CAN ASSIGN PARAMETER VALUE TO TEXT ITEM (HELP)
icon10.gif  HOW I CAN ASSIGN PARAMETER VALUE TO TEXT ITEM (HELP) [message #252525] Thu, 19 July 2007 02:05 Go to next message
hussienburhan
Messages: 28
Registered: July 2007
Junior Member
HI

I HAVE PARAMETER CALLED REFCOODE I ADD IT BY CHOOSING THE ORACLE VERTICAL MENU THEN CHOOSE PARAMETER AND PRESS GREEN PLUS SIGN BUT WHEN I WANT ASIGN ITS VALUE TO TEXT ITEM IT GIVE ME ERROE I TEIRD THIS CODE

BLK01.REFCODE:=:REFCOODE

BUT ITS GIVE :REFCOODE ITS NOT DECLARED IN ORACLE REPORTS I ASSIGN PARAMETERS IN THE SAME WAY SO HOW I CAN ASSIGN IT IN FORMS

PLEASE HELP Embarassed

Re: HOW I CAN ASSIGN PARAMETER VALUE TO TEXT ITEM (HELP) [message #252535 is a reply to message #252525] Thu, 19 July 2007 02:27 Go to previous messageGo to next message
zameersait
Messages: 16
Registered: July 2007
Junior Member
Use BLK01.REFCODE:=:Parameter.REFCOODE
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 Go to previous messageGo to next message
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 #252556 is a reply to message #252525] Thu, 19 July 2007 03:00 Go to previous messageGo to next message
zameersait
Messages: 16
Registered: July 2007
Junior Member
On WHEN-new-form-instance trigger of the second form, assign the :<BLOCK_NAME>.<TEXT_ITEM>=:Parameter.<PARAMETER_NAME>
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 Go to previous messageGo to next message
bahubcd
Messages: 36
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.
Re: HOW I CAN ASSIGN PARAMETER VALUE TO TEXT ITEM (HELP) [message #252958 is a reply to message #252525] Sat, 21 July 2007 00:07 Go to previous message
hussienburhan
Messages: 28
Registered: July 2007
Junior Member
Thank u very much bahubcd
,zameersait


Previous Topic: Problem with table migrating 6i to 10g
Next Topic: HELP IN TRIGGER EVENT
Goto Forum:
  


Current Time: Wed Dec 07 18:37:05 CST 2016

Total time taken to generate the page: 0.05391 seconds