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
- 2 Answers
- 4364 Views
- I also Faced
- E-Mail Answers
Answer Posted / sudipta santra
In form-1 the written code is given below:-
list_id := Create_Parameter_List('PAR_CONTRACT');
Add_Parameter(list_id,
'CONTRACT_NO',TEXT_PARAMETER,:TBL_CONTRACT.CONTRACT_NO);
call_Form('T:\Form-2.fmx',no_hide,no_replace,
no_query_only,list_id);
In form-2 the written code is given below:-
Either in the trigger When-New-Form-Instance or in trigger
Pre-Form :-
SET_WINDOW_PROPERTY(FORMS_MDI_WINDOW,WINDOW_STATE,MAXIMIZE);
BEGIN
IF ( :PARAMETER.PAR_CONTRACT IS NOT NULL ) THEN
/* Use this value in the WHERE clause of MY_BLOCK */
Set_Block_Property('TBL_CONTRACT',DEFAULT_WHERE,
'PAR_CONTRACT = :PARAMETER.PAR_CONTRACT');
GO_BLOCK('TBL_CONTRACT');
Execute_Query;
END IF;
END;
In that way we can use parameter inside the several forms.
If you have still any doubts , then please reach me out at:
sudipta_santra@infosys.com
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
can you convert or reverse engineer a fmx back to a fmb file?
what are the oracle forms services components include?
why the Ctl file u put only in bin folder why not in other folder
where do u put the report file
what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?
Explain how one can iterate through items and records in a specified block?
What do you understand by oracle forms and why are they required?
did u received a single file or multiple files
what is difference between group above and group left report
What is an oracle report?
Can we invoke one form from another in a multi-forms application?
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
How can we generate report output in excel format?
hiding item in report how like that properly,thats manually but at runtime i want to do
What is the difference between bind and lexical parameter?
