rounding issue
- Posted by gwalters Aug 20, 2010
- 979 views
I am having a rounding issue when comparing atoms. Here's the problem and I would like to know how to solve it.
sequence invoice, payments
I read from the database which is double type and add this to the invoice table.
invoice &= dbRec[invoice]
The value stored in invoice is not double eventhough it is double coming from the database.
e.g. the payment is 41204.33 but the invoice is 41104.32812 the components stored in the sequence appear to not be double. In the database it is correctly 41104.33 as reported by mysql.
If it makes any difference I'm still using EU 2.4 and Matt's odbc.
So do sequences store numbers as atoms with about 14-16 digits significance?
Comments appreciated
