adspace


how to create parameterised form in oracle 10g?
and create another form from the value of the form?
AND how to assign value to a parameter?
sincerly your
mamun

Answer Posted / sudipta santra

First U need to create one Param-List object inside the form
like as below:-

list_id := Create_Parameter_List('PAR_CONTRACT');
Add_Parameter(list_id,
'CONTRACT_NO',TEXT_PARAMETER,:TBL_CONTRACT.CONTRACT_NO);
call_Form('T:\Form2.fmx',no_hide,no_replace,
no_query_only,list_id);

in the Form2.fmb: You need to catch those parameter value in
either trigger Pre-Form or in trigger When-New-Form-Instance.

If you have any doubt then please drop me a mail about your
confusion on : sudipta_santra@infosys.com

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2227