Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 26th September 2017, 12: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
  #2  
Old 26th September 2017, 14:06
JaapJD's Avatar
JaapJD JaapJD is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 730
JaapJD will become famous soon enoughJaapJD will become famous soon enough
Baan: BaanIV, BaanERP, ERP LN 6.1 - DB: Oracle, SQL Server - OS: Unix, Windows
Ensure your script VRC is integrated with the package combination for which you defined the CDFs.
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
updating CDF fields using dal.set.field IndoTech Tools Development 1 27th June 2016 17:56
Undocumented Functions & Variables george7a Tools Development 81 30th September 2015 12:35
How to compare one double field's value with zero assassinator Tools Development 10 7th January 2009 03:26
Exchange - Only need to import date for a couple of table fields pjohns Tools Development 7 27th June 2003 10:06


All times are GMT +2. The time now is 12:32.


©2001-2017 - Baanboard.com - Baanforums.com