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

how to send file attachment from oracle forms

2502

---

What do you understand by lov and how can it be used?

1028

---

what is tripstop report?

1775

---

from where do u receive the information to develop report

1970

---

Why oracle forms required?

985

---

what are bind variables?

1026

---

What is the difference between bind and lexical parameter?

1022

---

how do u compile a form i.e .fmb file in Unix or in dos

4521

---

Explain how one can iterate through items and records in a specified block?

1039

---

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1851

---

How to create Drill down report?

2082

---

if u want to delete all these detail block etc what will happen in form

1936

---

In what sequence do triggers get fired by oracle forms?

918

---

What is responsibility and how u attach How to create user and how u attach with responsibility.

2000

---

what is a package n what r the packages availbla in report

2043

---