Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Large numbers with high decimal precision
Message
De
29/08/2011 20:23:45
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Large numbers with high decimal precision
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Divers
Thread ID:
01522171
Message ID:
01522171
Vues:
156
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform