>>>>>>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.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
