When I run a query to my postgres database, if the value in the table is a real number such 2676.06. In Xojo, the double variable that takes the value of recorset return 2676.0599999999999. Causing me problems with my reports.

Norman_P
(Norman P)
January 22, 2014, 6:08pm
2
When I run a query to my postgres database, if the value in the table is a real number such 2676.06. In Xojo, the double variable that takes the value of recorset return 2676.0599999999999. Causing me problems with my reports.

perfectly understandable

In computing, floating-point arithmetic (FP) is arithmetic that represents subsets of real numbers using an integer with a fixed precision, called the significand, scaled by an integer exponent of a fixed base.
Numbers of this form are called floating-point numbers.: 3 : 10
For example, 12.345 is a floating-point number in base ten with five digits of precision:
However, unlike 12.345, 12.3456 is not a floating-point number in base ten with five digits of precision—it needs six digits of pre...

use a currency value or something that IS precise