>>>
>>>George,
>>>
>>>There is a bug in TRANSFORM function.
>>>According to KB Article Q247494 "You might see that the results of the TRANSFORM() function appear off by approximately .0000000000001. This behavior may occur when COMPATIBLE is OFF."
>>
>>I'm aware of the KB article, however, if it were the fault of TRANSFORM(), my implemented solution would not work. Indeed, 145.6 when divided by 0.1 is 1456 as TRANSFORM() reported. Remember that the error occurs when comparing two numerical values, TRANSFORM() was only used to report the actual values, so it doesn't really come into play, except in the solution.
>
>And what was the actual value?
>Maybe it was 1456.0000000000001 or 1455.9999999999999 but TRANSFORM reported it as 1456.
TRANSFORM() may have reported it as 1456, but 145.6 / .1 should have also yielded that result. The problem is that it was a straight Boolean evaluation (ie. llBool = (lnNumber1 = lnNumber2)). Further, it worked fine on when called from within VFP, but, against the same data set did not within PowerBuilder.
George
Ubi caritas et amor, deus ibi est