Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG in VAL() function
Message
From
12/12/2003 13:26:17
 
 
To
12/12/2003 12:52:35
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00858634
Message ID:
00858696
Views:
16
>Hi Esparta,
>
>this is correlate with decimals:
>
>? VAL('$95.0000                    ')
>
>
>the workaround is:
>
>? VAL('$95.00                     '+'0')
>
>
>Fabio
This is pretty weird. I tried this on VFP6 SP5
? VAL('$95.0000                    ') &&returns 65631
? VAL('$95.0000                   ') &&returns 95.0010
? VAL(trim('$95.00                     ')) &&returns 95.0000
? VAL('$95.00ABCDEFGHILMNOHJYUIKDD') &&returns 95.0010
? VAL('$95.00                     '+'0') &&returns 65631
? VAL('    $95.00                     ') &&returns 95.0000
? VAL('     $95.00ABCDEFGHILMNOHJYUIKDD') &&returns 195.0000
? VAL('    $95 .00                     ')&&returns 195.0000
? VAL('    $95  .00                     ') &&returns 145.0000
? VAL('    $95   .00                     ') &&returns 95.0000
? VAL('    $95    .00                     ') &&errors with currency value is out of range
Previous
Reply
Map
View

Click here to load this message in the networking platform