Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INT()egering a Numeric type, expected value isn't correc
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00383077
Message ID:
00383507
Views:
16
>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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform