>>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?
>
>Jess,
>
>If n1 + n2 + n3 > 15.9994 then the value stored in the field will be 16.0000. INT(n1 + n2 + n3) = 15, but INT(amount) will be 16.
Referring to what Cindy told me, Money is the way to go but that's in SQL Server, isn't it. Could Currency data type will fix the problem?
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."