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

What is the difference between bind and lexical parameter?

1119

---

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1502

---

What is the difference between flex mode and confined mode?

1109

---

In what sequence do triggers get fired by oracle forms?

1020

---

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

2026

---

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

2190

---

What do we mean by record group in oracle forms?

1133

---

Can we invoke one form from another in a multi-forms application?

1174

---

what is oracle forms?

1158

---

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

1219

---

what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

1069

---

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

1946

---

List out the oracle forms configuration files?

1126

---

Is it possible to have multiple layouts in a report?

1086

---

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

2093

---