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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
can i write commit in Before report trigger
What is system.coordination_operation?
What is the use of Validation triggers in Reports?
What are the Coordination Properties in a Master-Detail relationship?
What is lexical parameter ?
Name the two files that are created when you generate the form give the filex extension ?
When will ON-VALIDATE-FIELD trigger executed ?
Whar are the different default triggers created when Master Deletes Property is set to Cascade?
What built-in is used for changing the properties of the window dynamically?
Can u explain me the Restricted and unrestricted procedure in Forms And reports and example as well ??
how to hide the scroll bar in forms 6i
What is the difference between NAME_IN and COPY ?