>>>>Why the return of 'int(12345678901234567.00)' is '12345678901234560' in VFP? It is bug?
>>>
>>>No, not really. There's a 16 digit limit of numeric accuracy. You can find it somewhere in the Help.
>>
>>SET VENT ON
>>
>>This is one of the biggest hurdles in converting our FPD2.6 app to VFP... The programmer used a 16 digit numeric field for the account number and when I open the accounts table in VFP, every account ending with 9 is rounded up !!!
>>
>>Seems like VFP has taken a step
backward in this regard.
>>
>>SET VENT OFF
>
>Just my opinion, but fields that will have not have mathematical calculations performed on them should not be numeric even if they consist of all digits. They should be character.
Absolutely. Like Rick, I learned this very early in my career and have never found a reason not to follow this rule.
George
Ubi caritas et amor, deus ibi est