Rounding problem
Posted: 06.10.2009, 05:13
Hi all,
I'm using BCB6+ZeosDBO 6.1.5 to connect MSSQL (MSDE).
In the table, I set a field data type as real and value set as 24445.21
When I query from the table and display at DBGrid, the value always display 24445.20. After I set to 24445.25, the value display as 24445.30
Even I set the display format as #,##0.00, the value still display like 24445.30
But, if I using ADO, the value display like 24445.25, it's correct.
Anyone know what's problem?
I'm using BCB6+ZeosDBO 6.1.5 to connect MSSQL (MSDE).
In the table, I set a field data type as real and value set as 24445.21
When I query from the table and display at DBGrid, the value always display 24445.20. After I set to 24445.25, the value display as 24445.30
Even I set the display format as #,##0.00, the value still display like 24445.30
But, if I using ADO, the value display like 24445.25, it's correct.
Anyone know what's problem?