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

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1479


What is a canvas in oracle forms?

587


Explain the different levels at which oracle form services interact.

601


Explain the various types of oracle report?

545


In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

812






What is an oracle report?

604


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

1294


In what situation u create the BPA.

1771


What is a matrix report and how many minimum groups are required to prepare the same?

550


What is the difference between bind and lexical parameter?

541


Is it possible to have multiple layouts in a report?

572


if u want to delete all these detail block etc what will happen in form

1473


How can we expand Parameter Form Canvas on Reports 6i?

1956


What is an implicit anchor and how is it a different form explicit anchor in a report builder?

629


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

1598