We want to write out floats with 6 decimal places to a FLOAT field in a MySQL database using the system.db.runPrepUpdate function.
We have found that if the value is small e.g. 0.000005 the system will try to send the number in exponential format i.e. 5.0E-6. However, there must be a problem occurring when the SQL query is constructed, because the value is stored in MySQL as 5.
We have tried writing exponential format numbers to MySQL using UPDATE SQL queries and they work perfectly. It would therefore seem that the problem is occurring somewhere between Ignition and MySQL.
We have found we can work around this problem by changing the number to a string, but this would be impractical to implement across our whole system.