Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Numeric overflow
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
01297788
Message ID:
01297824
Views:
20
>Ron,
>
>Numeric overflow means you are trying to put a number into a field that is not large enough to hold that number. I would strongly suggest that you change your phone number filed to character and get the formatting right for that data type. I say this becaues phone number are NOT numbers. Number are thing you need to do math to and I don;t think you will ever be interested in the sum of the phoine number or what the average phone number is.
>
>Make you phone number field a 10 character field and format it as "@R (999)999-9999" (if you are using only North American numbers).

ROFL
What's wrong with average phone number?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform