Answer Posted / guest

Restricted package procedure that affects the basic basic
functions of SQL * Forms. It cannot used in all triggers
except key triggers.

Unrestricted package procedure that does not interfere
with the basic functions of SQL * Forms it can be used in
any triggers.

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

1150

---

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

3321

---

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

2077

---

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2330

---

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

2959

---

if some data is not transfered where it will get stored

1991

---

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

1944

---

What is the difference between bind and lexical parameter?

1115

---

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

2050

---

Is it possible to have multiple layouts in a report?

1086

---

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

3046

---

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

1750

---

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

4615

---

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.

2279

---

i am writing a query select EmpNo from Emp how can i call in after parameter form

2185

---