IndoTech
26th September 2017, 12:04
Hi All
How to compare CDF fields of table and get other fields data?
e.g
select tisfc010.pdno, tisfc010.opno
from tisfc010
where tisfc010.cdf_orno = :r.po.no
and tisfc010.cdf_pono = :r.po.pos
selectdo
r.prod.ord = tisfc010.pdno
r.prod.pos = tisfc010.opno
endselect
for me it shows compile error - column not found tisfc010.cdf_orno
Regards
Kedar
How to compare CDF fields of table and get other fields data?
e.g
select tisfc010.pdno, tisfc010.opno
from tisfc010
where tisfc010.cdf_orno = :r.po.no
and tisfc010.cdf_pono = :r.po.pos
selectdo
r.prod.ord = tisfc010.pdno
r.prod.pos = tisfc010.opno
endselect
for me it shows compile error - column not found tisfc010.cdf_orno
Regards
Kedar