>>>>>>>>Any help ?
>>>>>>>
>>>>>>>Have you tried N(33,10) in VFP ?
>>>>>>
>>>>>>Create table testit (mynumber n(33,10))
>>>>>>
>>>>>>gives an error that "field width or number of decimal places is invalid"
>>>>>>
>>>>>>In the table designer the best I can get is 20,9
>>>>>>
>>>>>>Am I missing some trick?
>>>>>
>>>>>Sorry, have you tried B(10) ?
>>>>
>>>>Yes, and B(16)
>>>>
>>>>Both store 123456789012.12350000
>>>
>>>Did you check VFP Help Double Type?
>>
>>Again, yes. Double stores the number as 123456789013
>>
>>As Al and HIlmar have confirmed what I am seeing is a limitation of VFP.
>
>Have you tried shifting the decimal point? You could multiply by 100000 to shift the decimal point left for storing and then when retrieving divide back by 100000 for calculations. The number that you multiply/divide is determined by the number of significant digits that you want to maintain.
That won't change a thing. Double structure has an exponent and a mantissa which keeps 15.95 significant digits. Multiplying or dividing by a power of 10 has no impact on the mantissa, only on the exponent
http://en.wikipedia.org/wiki/Double_precision
Gregory