Transfer data through ADO

Pidi

More and more I´m using ADO to transfer data from 2.6(3.7) to 4.01 or from/to other data sources. I either use an ODBC DSN or the SQL Provider for SQL server. Everthing is fine so far ...

To access a 2.6(3.7) database however I have to use an ODBC data source based on the 3.7 ODBC driver that comes with Navision. This one works file as well, except I cannot access "DECIMALS" ot "TIME" values. The error message says "This datatype is not supported by C/Side - you have access to ...." (translation of german error message!).

Here´s a simple example, that won´t work with "Gross weight" since this is a DECIMAL, while the same code will work perfectly with any Code field:

IF NOT ADOrs.EOF THEN BEGIN
ADOrs.MoveFirst;
MESSAGE('Value: %1', FORMAT(ADOrs.Fields.Item('Gross weigt').Value));
...

Does anyone have any idea how to handle such values?

Thanks in advance

Pidi

kine

May be problem of "." or "," as decimal separator....

girish.joshi

I agree with kine that in your case, the problem is likely the characters in the data type.

You might want to check out this link:
http://www.mibuso.com/forum/viewtopic.php?t=8197

If nothing else, it will help you debug.