Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error in Numeric field
Message
From
10/12/2001 17:01:54
 
 
To
10/12/2001 16:45:17
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00592397
Message ID:
00592410
Views:
15
>Hi
>
>I am wanting to enter a barcode which can be up to 20 digits long.
>
>When I enter this into a Numeric(20,0) field the last four digits of my 20 digits get converted to 0's
>
>eg. 12345678901234567890
>becomes 12345678901234560000
>
>Is this a bug or is there some limitation I am unaware of.
>
>Also, is there a way to turn up the sound for the "you have replies" message?
>
>Regards
>Geoff Scott

Geoff --

OTTOMH, I believe you're running into a limitation with the internal representation of numbers in VFP. I thought it was somewhere's around 10^16-18.

I don't think any numeric representation will give you the resolution to the single digit that you need with values at 10^20. Can you use a character value?

Jay
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform