Updating numeric fields through ODBC
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 22.214.171.1245
FileMaker ODBC driver 12.03.103.00