Oracle Decimal Number data type retrived ignoring decimal points

[bidra]

Hi,

In Oracle the data is defined as NUMBER(8,2).

While using ODBC the decimal number datatype is retrieved by CR with the digets after the decimal point are now in front of it, for example:

10.12 is shown (and calculatedt with) as 1012.00
11.00 is correctly shown as 11.00

This error turned up using Oracle ODBC Driver 9.02, but not with the old Oracle ODBC Driver 8.01.

I am not sure if this is a only a problem of the ODBC driver or also a CR problem?

Thanx for any information!

Bidra

 

[synapsevampire]

You're still using the wrong ODBC driver, you'll encounter other problems with that.

Use the CR supplied ODBC driver.

-k