Subject | SQL : -625 / CHECK / |
---|---|
Author | Safak Ebesek |
Post date | 2003-10-16T21:37:15Z |
Hi,
I have added CHECK Constraint to one of my fields.
CHECK(VALUE>=0 AND VALUE<=100)
If user try to enter any value out range then Firebird send SQL Error
code as -625. I hande it and I show a message to user.
But I have no idea abouth the main source of -625. (Which field, what
is the range defined in CHECK, ...)
Is it possible to return my own defined error string instead of -625
at database level. (Like expections in stored procedures)
Thanks,
Safak
I have added CHECK Constraint to one of my fields.
CHECK(VALUE>=0 AND VALUE<=100)
If user try to enter any value out range then Firebird send SQL Error
code as -625. I hande it and I show a message to user.
But I have no idea abouth the main source of -625. (Which field, what
is the range defined in CHECK, ...)
Is it possible to return my own defined error string instead of -625
at database level. (Like expections in stored procedures)
Thanks,
Safak