| need help about the form6 report [message #88510] |
Wed, 23 October 2002 00:29  |
Sarita
Messages: 7
Registered: June 2002
|
Junior Member |
|
|
I need to calculate the lowest price (wt_rate ) in the given period i am writing the query
which am using in forms6 report.
select a.icode,b.iname,b.unit,a.po_no,
a.po_date,a.rate,a.wt_rate,
c.dis_per,c.st_per,c.ex_per,c.frt_per,c.cdays,c.pf_per
from po_order a,
invmast b, ord_det c
where a.icode= b.icode and a.po_no= c.po_no and a.po_date= c.po_dt
I have given the formula to calculate the lowest price(wt_rate) of
the item.
function CF_1Formula return Number is
fromdt date;
todate date;
cf_1 number;
begin
select min(wt_rate ) into cf_1 from po_order
where po_date >=fromdt and po_date <=todate
and icode=:icode ;
end;
after writing the pl/sql whenever I run this report . A Error come
ERROR
colomn 'cf_1' references coloumn 'icode',which has incompatible frequency
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
