>>Client's data has SQL columns of Decimal(22,10)
>>
>>I have remote views and controls bound to those views.
>>
>>How can I let the client enter 123456789012.1234567890 and have that saved to the back end.
>>
>>Seems the best I can do in a VFP cursor is 123456789012.1235000000 which is unacceptable. (
>>
>>B(16) float doesn't seem to help.
>>
>>Do I just tell them "sorry, VFP can't handle SQL numbers"
>>
>>Do I have to fiddle something using text fields and building SPT from scratch ( completely destroying the structure of the app for a couple of field values)
>>
>>Having kind of an I hate Foxpro day.
>>
>>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?
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.