Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
When to choose currency data type?
Message
From
20/08/2009 13:01:18
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
When to choose currency data type?
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01419279
Message ID:
01419279
Views:
146
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?
Next
Reply
Map
View

Click here to load this message in the networking platform