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 window?

2 Answers  

---

What is forms_DDL?

2 Answers  

---

Where do u define the select statement of the parameter? is it followed by the & variable ?

2 Answers   Zensar,

---

What are the different modals of windows?

1 Answers  

---

how to create parameterised form in oracle 10g? and create another form from the value of the form? AND how to assign value to a parameter? sincerly your mamun

2 Answers  

---

Oracle me hindi notes chahiye or any web site address plz Give me in my email add,/////////// sunny.145@rediff.Com

2 Answers  

---

What is a timer?

1 Answers  

---

How can you create Lexical parameter n Bind parameter in Reports ?

1 Answers   GE, SVSS,

---

What is a library?

1 Answers  

---

What is a Layout Editor?

2 Answers  

---

running a report from Form or other Report , The Parameter Form Page will be Display first . I don?t want to display the screen . What I have to do ?

1 Answers   Convergys,

---

What is an user exit used for?

1 Answers  

---