Please tell me what is wrong in the below query:
(Very Urgent)
=================================================
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 then
aiv.INVOICE_DATE between :from_invoice_date
and :to_invoice_date
end if;
return (TRUE);
end;
Answers were Sorted based on User's Feedback
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?
Is This Answer Correct ? | 0 Yes | 0 No |
What are the built-ins that are used to Attach an LOV programmatically to an item?
Which is the cheapest and quality Oracle Education provider in Bangladesh?
based on parameter value layout of report should change
Can you attach an lov to a field at run-time? if yes, give the build-in name.
if some data is not transfered where it will get stored
What are different types of images?
What are the different types of Coordinations of the Master with the Detail block?
How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff
what is Oracle10g? Please refer some sites...
What is an implicit anchor and how is it a different form explicit anchor in a report builder?
What do you mean by a block in forms4.0?
Deleting a page removes information about all the fields in that page ?