Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Large numbers with high decimal precision
Message
 
 
To
29/08/2011 20:23:45
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01522171
Message ID:
01522183
Views:
79
>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 ?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform