Problem with numeric values OpenEdge

P

peers

New Member
Hi,

I am using ODBC (Progress OpenEdge 10.2A to access a DB on a dutch PC and having trouble with numeric values. The decimal point and 1000 seperator are retreived 'reversed'. This causes numbers to become invalid in the dutch notation. For example 0.1 is retreived as .1 which is no numeric value in the dutch notation (this should be 0,1) causing the program to crash. Other values are also retreived wrong for example 1 becomes 100000000 (8 zero's are added to each value >0).

We did not have this issue on our old db, accessed with the DataDirect 4.10 driver.

So the question is: How can i reverse the decimal and 1000 seperator?
 
What is it that you use to read data using ODBC (aka the application that crashes)?

Normally the decimal point has any meaning only at presentation layer, a numeric value is stored as an integer/decimal regardless of the numeric format you use and ODBC should give you the data as it is if that's a numeric field and we're not talking about string formatted as numbers, check the data-type of the field as seen by ODBC.
 
You must log in or register to reply here.
Back
Top