Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Double vs Numeric
Message
From
19/03/2012 10:36:35
 
 
To
19/03/2012 10:20:17
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01538640
Message ID:
01538658
Views:
39
>>Hi All,
>>
>>In all my years of using VFP I cannot remember ever using a Double type field in a table. Now I need to store numeric values which exceed 10 digits before the decimal point and up to 4 digits after the decimal point giving me a numeric field of 15,4. However, I notice that a double field type takes up 8 bytes which would be less than a numeric field catering for 15,4. Are there any obvious problems or issues to be aware of if I convert to using doubles as a field type, any things to watch or check for?
>
>My only comment is that I have heard that you should avoid Currency, it apperantly has some flaws.

I use it only seldom, mostly for very large counters - mostly =+ type of counting.
But if you need 19 digits of precision, would you trust vfp's numeric esp. if vfp help is quite open about precision ?
Perhaps the safest way would be to use C(20) and work from there if no calculation is needed.

my 0.02 €

thomas
Previous
Reply
Map
View

Click here to load this message in the networking platform