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
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?
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
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
i am writing a query select EmpNo from Emp how can i call in after parameter form
Name the different triggers associated with oracle forms having a master-detail relationship.
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame
why the Ctl file u put only in bin folder why not in other folder
how do u compile a form i.e .fmb file in Unix or in dos
what is oracle forms?
What is an SQL FORMS ?
What is a canvas in oracle forms?
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?
what is difference between group above and group left report