dbTalk Databases Forums  

Wrong value returned when accessing numeric fields with JDBC

comp.databases.filemaker comp.databases.filemaker


Discuss Wrong value returned when accessing numeric fields with JDBC in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sébastien Wautelet
 
Posts: n/a

Default 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




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.