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?

Can a property clause itself be based on a property clause?

1 Answers  

---

What are the difference between lov & list item?

1 Answers   ESS,

---

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

1 Answers  

---

What is relation between the window and canvas views?

2 Answers   ABC,

---

What is the difference between flex mode and confined mode?

1 Answers  

---

what are the oracle forms services components include?

1 Answers  

---

What is an implicit anchor and how is it a different form explicit anchor in a report builder?

1 Answers  

---

Name the two files that are created when you generate the form give the filex extension ?

2 Answers  

---

How many number of columns a record group can have?

2 Answers  

---

Explain about horizontal, Vertical tool bar canvas views?

1 Answers  

---

how to send sms to mobile phone from oracle forms.

1 Answers   HP, Tech Mahindra,

---

How do u give the list of values in bind parameter

1 Answers   Zensar,

---