Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to format a currency fields ?
Message
De
29/11/1999 07:11:57
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00294286
Message ID:
00296317
Vues:
25
I strongly advise NOT to use currency fields. I have used them and realized they don't work (at least not in my apps)
I calculate interest for govenment bonds and they were hundreds of Dollars off.
Changed the field type to N(17,2) and everything balances to the penny!

(My 2 cents (numeric 10,2))

Peter


>>I have my currency set as $ in the option menu of foxpro. However, when I browse some datafields, they come with 4 decimals. Same in my forms. Do I have to perform some SET CURRENCY stuff?
>
>Eric,
>
>Currency data type has fixed 4 decimals. If you want to only see 2 then you need to either use the ROUND() function or set the Inputmask to 999,999,999.99.
Peter Cortiel
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform