Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Serious Error with Currency Data Type
Message
 
 
To
18/01/1999 12:40:19
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgia, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00177250
Message ID:
00177261
Views:
41
Calvin,

According the the VFP5 help file:

If you specify more than four decimal places in a currency expression, Visual FoxPro rounds to four places before evaluating the expression.

So it's working as documented the 0.41116 is being rounded to 0.4112 before the expression is evaluated. You may have to take the currency numeric to get the precision you need during the operation.

>I have found that using currency data types results in incorrect answers for simple math operations. For example, if I have a currency value and multiply it by a decimal value it appears that foxpro converts the decimal value to a currency type before the operation rather than after the operation. Test the following on your machine:
>1050.45 * .41116=431.9030
>$1050.45 * .41116=431.9450
>
>This has got to be an error and it renders currency virtually useless without doing mton conversions everywhere.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform