BUG: Incorrect Evaluation of Equation with Variables (164359)


The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 5.0
  • Microsoft Visual FoxPro for Windows 6.0
This article was previously published under Q164359

SYMPTOMS

In Visual FoxPro 5.0 and higher, an equation that contains variables may not be evaluated correctly.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

In the Command window, issue the following commands: 
   SET DECIMALS TO 5
   mVar = 1
   ? mVar + (1048575+(mVar/1000)) = 1048576.001
The value .T. (True) should be echoed to the screen but .F. is returned instead.

The following recommendations may be used as alternative solutions to this problem:

  • Replacing mVar (inside the parentheses) with 1 exhibits the correct behavior, as does removing the outside parentheses.
  • Using the ROUND() function may also solve this problem: 
          ? ROUND(mVar+(1048575+(mVar/1000)), 5) = 1048576.001
This behavior does not occur in Visual FoxPro 3.0.
Modification Type:MajorLast Reviewed:10/15/2003
Keywords:kbBug KB164359
©2003 Microsoft Corporation. All rights reserved.