Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan : Installation :

the "numer" field does not enforce a number

Jul 30, 1999, 9:27 AM
coolfred
Novice (17 posts)
Jul 30, 1999, 9:27 AM
Post #1 of 3
Views: 1850
Shortcut
Quote Reply
the "numer" field does not enforce a number
Hi;

I tried using the numer field to enforce a "number" input into a field but it is not working and the user can enter any text and it is accepted by the database... how can I fix this?
Jul 29, 1999, 10:11 PM
JPDeni
Veteran / Moderator (8669 posts)
Jul 29, 1999, 10:11 PM
Post #2 of 3
Views: 1718
Shortcut
Quote Reply
Re: the "numer" field does not enforce a number In reply to
You are correct. The "numer" data type does not enforce a number. It is used for sorting purposes and doing "greater than" and "less than" searches.

There is a way to enforce a number, however. How large of a number do you want to allow?

------------------
JPD





Jul 29, 1999, 10:19 PM
coolfred
Novice (17 posts)
Jul 29, 1999, 10:19 PM
Post #3 of 3
Views: 1716
Shortcut
Quote Reply
Re: the "numer" field does not enforce a number In reply to
It is going to be a "price" field... such as $ 10 or $ 423 ... I need to force people to enter numbers rather than letters.