Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Large numbers with high decimal precision
Message
From
29/08/2011 20:23:45
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Large numbers with high decimal precision
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01522171
Message ID:
01522171
Views:
157
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 ?


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.
Next
Reply
Map
View

Click here to load this message in the networking platform