Professional Web Applications Themes

Wrong value returned when accessing numeric fields with JDBC - FileMaker

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 ...

  1. #1

    Default Wrong value returned when accessing numeric fields with JDBC

    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



    Sébastien Wautelet Guest

  2. #2

    Default Wrong value returned when accessing numeric fields with JDBC

    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





    Sébastien Wautelet Guest

Similar Threads

  1. accessing html fields
    By Jessica Weiner in forum ASP.NET Building Controls
    Replies: 1
    Last Post: July 5th, 04:56 AM
  2. CF 7 Standard + Oracle JDBC drivers + CLOB fields
    By Mustache2 in forum Coldfusion Database Access
    Replies: 2
    Last Post: February 15th, 04:24 PM
  3. Do Database fields have a numeric equavilant?
    By technoplonker in forum ASP Database
    Replies: 1
    Last Post: January 13th, 03:40 PM
  4. Replies: 3
    Last Post: July 9th, 10:25 AM
  5. ViewState can't handle numeric fields?
    By Boban Dragojlovic in forum ASP.NET General
    Replies: 0
    Last Post: June 24th, 03:04 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139