Answer Posted / farrukh shaikh

Assalam-o-Alikum.
you can pass the value of two variable from form F1 to form
F2
First you have to create the two parameter on form F2 name
p1 and p2 and save the form.
then you go on to F1 and write tis code on button on text
item through which you want to send the parameter.
Declare
para ParamList;
Begin
para:=get_parameter_list('plist') /*plist can be replace by
any character*/
if not id_null(para) then
destroy_parameter_list('plist');
end if;
para:=create parameter_list('plist');
Add_Parameter(para,'P1',variable_1);
Add_Parameter(para,'P2',variable_2);
---after this you can add
call_form('F2');
--you can see the argument pass through form F1 to FORM F2.
end;

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

1471

---

Explain the various types of oracle report?

539

---

Is it possible to execute a dynamic sql from forms?

590

---

I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

2267

---

In what situation u create the BPA.

1770

---

---

What do we mean by record group in oracle forms?

602

---

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

1468

---

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

587

---

i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

2460

---

In what sequence do triggers get fired by oracle forms?

529

---

what is tripstop report?

1348

---

hiding item in report how like that properly,thats manually but at runtime i want to do

2537

---

from where do u receive the information to develop report

1522

---

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.

1687

---

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

1690

---