Wrong value returned when accessing numeric fields with JDBC -
07-31-2003
, 06:45 AM
I'm accessing a FMPro 5.5 database from a Java program through the JDBC
driver, but I'm having problems with numeric fields with a decimal part (I
have no problem with text fields). The value returned by the driver seems to
always be an integer number made of all the digits, without the decimal
separator. For instance :
5,23 in FMPro becomes 523 in Java
12,47 becomes 1247
and so on...
Could it be a problem with my locale? I thought about that because every
time I open the database in FMPro I get a warning about the date/hour format
in the file being different from the system format. So I've tried changing
the decimal separator (, or .) in the Windows 2000 control panel but without
any success...
Anyone knows how to fix this problem?
Thanks in advance
Sebastien |