09-17-2019 12:40 AM
We remarked that fields defined as 'Number' are stored wrong if you have big values or float numbers.
Input Stored Value in Form and database 25.50 25.50 -> OK 25.55 25.549999 -> not OK 7777777 7777777 -> OK 77777777 77777776 -> not OK
Field 'aaa' in database table is configured as float (SQL Server)
We also tested type numeric(12,2), but it's the same behavior.
<Field Name="aaa" Type="Number" />
<Editor Name="aaa" Title="AAA"/>
Is there a better type than 'Number' we can use for?
Thank you very much,