Microsoft KB Archive/138042

= PRB: MOD with One Negative Number Returns Incorrect Result =

Article ID: 138042

Article Last Modified on 10/15/2003

-

APPLIES TO


 * Microsoft FoxPro 2.6a Standard Edition
 * Microsoft Visual FoxPro 3.0 Standard Edition

-



This article was previously published under Q138042



SYMPTOMS
When using the MOD function with one negative number and the expected result is the numerator, FoxPro returns the wrong value. For example, MOD(9,-10) returns -1. The correct result should be 9.



CAUSE
This occurs because the MOD function was designed to maintain compatibility with the dBASE MOD function, which also returns this result.

NOTE: dBASE is manufactured by Borland International Inc., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.



RESOLUTION
Create a function similar to the following and use this function instead of MOD. FUNCTION INTMOD PARAMETER x,y        && where x is the numerator, y is the denominator z = x - INT(x/y)*y RETURN z             && where z is the expected result



STATUS
This behavior is by design.

Additional query words: VFoxWin FoxWin akz

Keywords: KB138042

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.