|
| |
|
|
titans13
Posts: 31
From: Nashville TN USA
Status: offline
 |
Out of present range? - 8/13/2002 17:30:18
Here' s a stumper...at least for me.
Using DRW with an Access database.
Using a web form to enter data (tracking numbers), if you enter any number from 0-2,140,000,000 (I am using commas here only so you can see the number better...they are not used in the database) the database takes the info successfully. If a number 2,150,000,000 or above is entered, the database cannot successfully take it, and I get the following message:
Cannot save value " 2150000000" to database field " AirbillNumber"
Error Description: Out of present range.
Error Number: -2147352566
Error Source: Provider
The magic definitive number is obviously between 2140000000 and 2150000000. Forgive me if I have not taken the time to test all numbers in between to track it down :)
I cannot see any restrictions on this field in design view. Is this a limitation of some sort I am not aware of?
|
|
|
|
Doug G
Posts: 1191
Joined: 12/29/2001
From: SoCal
Status: offline
|
RE: Out of present range? - 8/13/2002 20:28:58
Or, it may be the datatype you have used in your database has maxed out, i.e., Integer in sql server maxes out at 2 or 4 gb. Try using a datatype that supports huge values if it' s a numeric column.
_____________________________
======
Doug G
======
| |
|
|
|
ou812
Posts: 1705
Joined: 1/5/2002
From: San Diego
Status: offline
|
RE: Out of present range? - 8/13/2002 23:07:54
The default in Access when storing integers is a Long Integer which will store numbers from –2,147,483,648 to 2,147,483,647 (no fractions).
You can either change it to " maybe" a single or double or as suggested a text field. I' ve used text for airbill numbers before since you don' t really need to do any calculations on them, unless of course you are working with checkdigits etc. Then you would need to check it as a number prior to storing as a text.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
