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
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
What is a canvas in oracle forms?
Explain the different levels at which oracle form services interact.
Explain the various types of oracle report?
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
What is an oracle report?
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
In what situation u create the BPA.
What is a matrix report and how many minimum groups are required to prepare the same?
What is the difference between bind and lexical parameter?
Is it possible to have multiple layouts in a report?
if u want to delete all these detail block etc what will happen in form
How can we expand Parameter Form Canvas on Reports 6i?
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables