Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Serious Error with Currency Data Type
Message
 
 
À
18/01/1999 12:40:19
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00177250
Message ID:
00177261
Vues:
30
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform