 |
Selrach
Newbie
Joined: 14 Jan 2012
Posts: 8
|
 Posted: Wed Jan 28, 2015 5:42 am
Database Number Field Maximum Value
|
Am wondering if there's any method to increase the maximum value for the number field beyond 999,999.
I'm trying to store numbers which can be as large as 30 million, however the max it allows is 999,999.. that said, I have it storing numbers higher than 10 million, it's just if I access the individual record, it changes the values for that record down to 999.999.. viewing them on the list though seems to be fine and the value saves through closing the database/client. the only issue is what the client allows the maximum to be set to. |
|
|
|
|
shalimar
GURU
Joined: 04 Aug 2002
Posts: 4797
Location: Pensacola, FL, USA
|
Posted: Wed Jan 28, 2015 6:12 am
|
maybe change the field into a string and convert it back to a number as needed?
|
|
|
|
|
Selrach
Newbie
Joined: 14 Jan 2012
Posts: 8
|
Posted: Wed Jan 28, 2015 6:42 am
|
Yeah.. I've considered doing that, but have been leaving it as the last resort, as I dislike storing numbers as strings. =/
If no other alternative presents itself though, I guess I'll have to. *shrug* |
|
|
|
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
