Answer / hari

else if body is not correct.

Answer / sudipta santra

The function will be like that:-

function BeforePForm return boolean is
begin
if :from_invoice_date is null OR :to_invoice_date is null
then
aiv.PERIOD_NMAE:=:gl_period
elsif :gl_period is null or aiv.INVOICE_DATE between
:from_invoice_date and :to_invoice_date then
aiv.PERIOD_NMAE:=<insert value>
end if;

return (TRUE);
end;

Like that way it will be solved. In else part the assigned
value should be fixed how it would between two range of date?

What is a predefined exception available in forms 4.0?

2 Answers  

---

What are the master-detail triggers?

1 Answers  

---

how we can validate the run-time parameters in reports 6i

1 Answers   Satyam,

---

What are the different types of Delete details we can establish in Master-Details?

1 Answers  

---

HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.

2 Answers  

---

what is procedure like symbols of bind and lexical

1 Answers  

---

how will the report recognize the parameter

1 Answers  

---

How can you format a character field in a report Layout editor ?

1 Answers   Convergys,

---

What is synchronize?

2 Answers  

---

Explain how can you use the same lov for 2 columns?

0 Answers  

---

what u write in Ctl file

2 Answers  

---

What are modalless windows?

1 Answers  

---