Microsoft KB Archive/135115

= PRB: VAL Does Not Return Error When Number Is Out of Range =

Article ID: 135115

Article Last Modified on 2/15/2000

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition

-



This article was previously published under Q135115



SYMPTOMS
Assigning a variable a number that is out of the allowed range for double precision numbers doesn't generate an error.



STATUS
Microsoft is researching this behavior and will post new information here in the Microsoft Knowledge Base as it becomes available.



Code to Reproduce Behavior
Create and run this program: CREATE TABLE test (numeric N(10,5), float F(10,5), ;  double D, currency M, integer I) APPEND BLANK nBig=VAL('1E+700') && largest double precision number has an exp of 308

? TYPE ('nBig')            &&  prints 'N' ? nBig                      &&  prints ******** ? STR(nBig,203,7)          && prints 203 *'s REPLACE numeric WITH nBig   && Numeric overflow. Data was lost REPLACE float WITH nBig    && Numeric overflow. Data was lost REPLACE double WITH nBig   && data type mismatch REPLACE currency WITH nBig && data type mismatch REPLACE integer WITH nBig  && Numeric overflow. Data was lost ? LOG(nBig)                && prints 20 asterisks

Additional query words: 3.00 VFoxWin

Keywords: KB135115

-

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

© Microsoft Corporation. All rights reserved.