Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
When to choose currency data type?
Message
De
20/08/2009 13:01:18
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
When to choose currency data type?
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01419279
Message ID:
01419279
Vues:
145
Hi,

I can find very little discussion about using Currency data type field when designing table structure in all my VFP books.

VFP9 help's tip says: "For precise financial calculations, use the Currency data type instead of Numeric. "
But I know currency data is always calculated with 4 decimal places... and that can cause calculation like $1000 * (1/3) to end up inaccurately...

So, what are the pros and cons of using currency data type? What should I consider when choosing between numeric and currency data type?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform