Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Number or Currency?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00747637
Message ID:
00747746
Vues:
17
>>>Hi,
>>>Should I use currency or Numeric N(14,2) data type for Cost, selling price and sales amount?
>>>
>>>Thank you
>>
>>I personally never use Currency to avoid all potential rounding problems with this field type.
>
>I knew there was a reason for me using numeric versus currency but I just couldn't think of it ;)
>
>Einar

I fixed a couple of somebody's applications by changing from Currency to Numeric. They were often 1-2 cents off in their calculations. No big deal really, but you know, accounting staff does not like this very much. :)
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform