Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why?
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Re: Why?
Miscellaneous
Thread ID:
00380373
Message ID:
00380733
Views:
14
>>>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform