Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
About Currency data type?
Message
From
23/09/1999 11:24:50
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00266701
Message ID:
00268008
Views:
21
>>Is it true that calculations with Currency fields are faster than with numeric fields?
>
>Hi Christian,
>
>Part of this is a SWAG. I assume that currency fields are stored as a double precision eight byte floating point. This means that it'll have to be converted for display, but not for calculations. Numeric values are stored in the table as character. There's no need to convert for display, but they do have to be converted for calculations.

Currency field is a quad integer, and gets divided by 10000 for display and conversion purposes, and due care is taken when multiplying and dividing. That makes it really fast.

back to same old

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

Click here to load this message in the networking platform