display of non-integer numbers in table

[RB Smissaert]

When I have a SQLite table with a field that is defined as REAL (in the create table SQL) and where all the values in that field are rounded to 2 decimals (update table1 set field1 = round(field1, 2) then when I get that SQLite in a table control (cmd.ExecuteTable etc.) then there will be more than 2 decimals showing in the table control.
The only way to get the 2 decimals and no more is to do another round in the cmd.CommandText.
Is this a bug or am I missing something here?
This is both on the desktop and the device.

RBS

 

[Erel]

The number is stored in the database as a binary number, not a string.
It is possible that the binary representation is not completely accurate. So you get trailing zeroes.

 

[RB Smissaert]

Yes, that must be it.
Other apps though somehow don't show these extra figures.

RBS