Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INT()egering a Numeric type, expected value isn't correc
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00383077
Message ID:
00383507
Vues:
17
>We have a field which is set as Numeric type say Amount N(10,4). Value of
>which was derived from different variables and fields (n1+n2+n3, etc.).
>Somewhere in the module, it is clear that Amount has a value of 16.0000 being
>shown in the debugger, but if we try to make use of INT(Amount), it gives us
>15. Trying to do the same procedure in the command window but this time using
>variables, it produces the correct result. Is there a hidden anomaly of
>using a Numeric type?

As mentioned by several others, the answer here is yes. As suggested in Q258998, you might be able to use ROUND(nAmount, 0) instead of INT(nAmount) to get the value you expect.
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform