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

How can we call a URL from a menu (Oracle Forms 6i)?

2 Answers  

---

How i get the client machine Ip address through developer 2000 forms, if you are running three tier architech.

1 Answers  

---

Whar are the different default triggers created when Master Deletes Property is set to Cascade?

1 Answers  

---

What are the built-in used for getting cell values?

1 Answers  

---

How many number of columns a record group can have?

2 Answers  

---

---

What are the different display styles of list items?

1 Answers  

---

a text item is there what r the different types of triggers associated with it

0 Answers  

---

What is the sequence the Report triggers will fires while running a report ?

1 Answers   FCS, GE,

---

What are the types of calculated columns available?

1 Answers  

---

What triggers are associated with the radio group?

1 Answers  

---

Can a property clause itself be based on a property clause?

1 Answers  

---

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

0 Answers  

---