I have another problem that seems to be caused by my language setting using ‘.’ instead of ‘,’.
The runPrepUpdate function inserts wrong values for floats. The statement in the following code inserts 25 and 20 instand of 2.5/2.0. The float value 98,99 is inserted as 9.899e+15.
system.db.runPrepUpdate(INSERT INTO table(id, faktor, faktor_anz) VALUES (?,?,?,?,?,?,?,?,?,?), [9998, 2.5, 2.0], , , false)
There seems to be a general problem with number formatting when using system languages that uses a comma as decimal seperator. One of this issues (http://www.inductiveautomation.com/forum/viewtopic.php?f=72&t=8804) has been solved in the last beta, another is still open (http://www.inductiveautomation.com/forum/viewtopic.php?f=72&t=8780).
I know that localisation of Ignition has no high priority, but the number format should be urgently fixed. Currently as a workaround i use a manual float to string conversion for all user input in clients, but that can not be a permanent solution.