Hi
Im having an issue with an ODBC connection into an OEV10 DB.
Background: Our main ERP system runs on Progress 9.1c, our T&A system on OEV10. We have reports in 9.1c which "pull" data from OEV10 into 9.1c. Therefore the ODBC connection is pulling into 9.1c from the OE DB.
When im retrieving data all data types work, string, integer, logical - with the exception of DECIMAL.
Any decimal value that is retrieved returns a "?" when im using the connection on the 9.1c DB. However, if the same connection is used in Excel it shows a value.
Im using the following command:
Analysis_Value = ObjRecordSet:FIELDS("Analysis_Value"):VALUE
This works for all other fields of any type - but not for any that are decimal.
Can anyone advise?
Regards
Ian
Im having an issue with an ODBC connection into an OEV10 DB.
Background: Our main ERP system runs on Progress 9.1c, our T&A system on OEV10. We have reports in 9.1c which "pull" data from OEV10 into 9.1c. Therefore the ODBC connection is pulling into 9.1c from the OE DB.
When im retrieving data all data types work, string, integer, logical - with the exception of DECIMAL.
Any decimal value that is retrieved returns a "?" when im using the connection on the 9.1c DB. However, if the same connection is used in Excel it shows a value.
Im using the following command:
Analysis_Value = ObjRecordSet:FIELDS("Analysis_Value"):VALUE
This works for all other fields of any type - but not for any that are decimal.
Can anyone advise?
Regards
Ian