Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Currency vs numberic
Message
From
16/08/1999 14:44:00
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
16/08/1999 10:16:15
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00254029
Message ID:
00254190
Views:
20
>Hi,
>
>what is the advantage /reason for using a currency data type vs just using a numeric in a table field?
>
>thanks!

Internally, currency data type is integer (8 bytes long, AFAIK), and it gets divided by 10000 for display purposes, and also when multiplying. Therefore, it should be faster for standard financial calculations than the standard numeric type, which is stored as ASCII in tables and as IEEE float in the memory. Currency type doesn't need this sort of conversion, and should perform (basic) calculations faster.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform