Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4753 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
What is the difference between bind and lexical parameter?
did u received a single file or multiple files
what are the oracle forms services components include?
Is it possible to have multiple layouts in a report?
hiding item in report how like that properly,thats manually but at runtime i want to do
in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory
if some data is not transfered where it will get stored
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
What are the various configuration files that are used by oracle forms?
all steps of bitmap report?
How to create Drill down report?
what exactly u write in when_new_form_instance
i am writing a query select EmpNo from Emp how can i call in after parameter form
did u p prepared complex report
