|
Home > Archive > Oracle certifications > June 2002 > Forms Parameters
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| odonata 2002-06-21, 9:19 pm |
| HI.
I am studying Oracle Forms for Forms II exam and am in the section on paramlist. Ok, I have 2 forms, in the first form (the calling form) I created a paramlist programmatically in a when-button-pressed trigger which also calls the second form using OPEN_FORM built-in. In the second form (the called form), I created the paramlist, but now what I can't figure out is how do I get the information out of the paramlist in my called form??
Thanks for any help!  | |
| mhusain 2002-06-26, 7:17 am |
| Here is an example to pass data b/w two forms using form parameters
when-button-pressed trigger on
CTL.OPEN_ORDITEM item:
DECLARE
v_pl_id PARAMLIST;
BEGIN
IF not ID_NULL(GET_PARAMETER_LIST('cu
s')) THEN
DESTROY_PARAMETER_LIST('cus');
-- destroy if any existing list exist
END IF
v_pl_id :=CREATE_PARAMETER_LIST('cus')
-- create a list
ADD_PARAMETER(v_pl_id,'cus_id'
,text_parameter,TO_CHAR(:cus.id)); -- add parameter 'cus_id' in this eg with a value of bind variable :cus.id
OPEN_FORM('orditem',activate,n
o_session,no_share_library_dat
a,'cus'); -- call the target form and pass the list 'cus' to it
END
NOTE You must define the CUS_ID parameter in the ORDITEM form at design time, because each run time parameter must have a corresponding design time parameter in the target form.
Reference form parameters using PARAMETER.parameter_name.
In the above case it will be cus.cus_id in ur target/called form
Hope this helps
Mohammad
mhusain714@yahoo.com | |
| odonata 2002-06-26, 7:19 am |
| Thanks!
Yes, it helps. |
|
|
|
|