Hi,
Among other tables I'm trying to get data from the Item table in NAV 4 (runtime NAV 2009) by using NODBC. The other tables are running fine but when I reach the Item table I get the error message "Non Unique Column Reference 'Common Item No.' ". I have checked the captions of all the fields in the Item table and all captions are unique - I have even tried renaming the caption of the field 'Common Item No.'.
Any one having an idea on how to overcome the problem?
Finn Landgreen-P
www.corpital.com0
Comments
Try: "Common Item No_"
SQL SELECT Description as ItemDesc,
"Gen_ Prod_ Posting Group" as CategoryID,
"No_" as ItemID,
"Vendor No_" as VendID
FROM Item;
www.corpital.com
Look for identical captions in the tabel and change it then it'll work.
NAV Freelance Consultant
It would have been nice if the 'Non unigue column reference' message came with the field name that actually gave the problem....
www.corpital.com
Thank You for help haha (karma after 3 years
M