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

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

What are the menu items that oracle forms 4.0 supports?

1 Answers  

---

What is 4-way match?

2 Answers   Zensar,

---

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

0 Answers  

---

Name the different triggers supported by oracle reports and their firing order.

0 Answers  

---

What are the default parameter that appear at run time in the parameter screen?

1 Answers  

---

how can u store a picture file in oracle database? explain the path/command?

1 Answers   GE, Satyam,

---

Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?

1 Answers  

---

HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.

2 Answers  

---

hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

0 Answers   IBM,

---

Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

0 Answers  

---

What is strip sources generate options?

1 Answers  

---

What are the different defaust triggers created when Master Deletes Property is set to Non-isolated?

1 Answers  

---