View Single Post
  #1  
Old 26th September 2017, 11:04
IndoTech's Avatar
IndoTech IndoTech is offline
Member
 
Join Date: Jul 2005
Posts: 72
IndoTech is on a distinguished road
Baan: Baan IV, Infor LN 10.4 - DB: SQL-Server2000, Oracle, Informix - OS: Windows NT, Unix
Compare CDF fields
Baan: ERP LN 6.1 FP10 (Infor ERP 10.4)
C/S: Both

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
Reply With Quote