Subject | Int field restriction |
---|---|
Author | Allysson Costa |
Post date | 2007-07-19T14:20:20Z |
Dear friends,
I have a smallint field in my database table (Firebird).
I need make a restriction, at database level, where I can permit only the number 0 (zero) repeat. Numbers greater than 0 can't repeat.
I can do it in my interface application but I want to do it by using database resources.
I think to create um "check" or other thing. Anyone can help me. What can I do to solve this using database resources?
Thanks in advance.
Allysson.
Flickr agora em português. Você cria, todo mundo vê. Saiba mais.
[Non-text portions of this message have been removed]
I have a smallint field in my database table (Firebird).
I need make a restriction, at database level, where I can permit only the number 0 (zero) repeat. Numbers greater than 0 can't repeat.
I can do it in my interface application but I want to do it by using database resources.
I think to create um "check" or other thing. Anyone can help me. What can I do to solve this using database resources?
Thanks in advance.
Allysson.
Flickr agora em português. Você cria, todo mundo vê. Saiba mais.
[Non-text portions of this message have been removed]