AnsweredAssumed Answered

Updating numeric fields through ODBC

Question asked by DmitryShapovalov on Oct 29, 2014

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

Outcomes