0 Replies Latest reply on Oct 29, 2014 3:23 PM by DmitryShapovalov

    Updating numeric fields through ODBC

    DmitryShapovalov

      Title

      Updating numeric fields through ODBC

      Your post

      Whenever numeric field is updated through ODBC, instead of integer value which is provided in the SQL it writes into the database float with six zeros after the dot (for example, if I write 12, I see in the database 12.000000). Is there any way to fix it? We just use integer values in those fields (number of seat, reference id, etc.), so those zeros look creepy:-) It seemed to work fine in prior versions.

      FileMaker Server 12.0.4.405 

      FileMaker ODBC driver 12.03.103.00