Subject Int field restriction
Author Allysson Costa
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]