enforcing constraints

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

As far as I can tell constraints like uniqueness are only enforced at the
update event. It seems more sensible to enforce them at the row or column
change event, i.e. as soon as the person inputing the info makes the mistake.
Is there a way to automatically enforce constraints on the row or column
change events?
 
rossu said:
As far as I can tell constraints like uniqueness are only enforced at the
update event.
Click to expand...
Or at the insert (or at the delete) event

It seems more sensible to enforce them at the row or column
change event, i.e. as soon as the person inputing the info makes the mistake.
Click to expand...
Maybe not... because the value of a field might depend on the values of
other fields (for example, if the field Status has value of "Cancelled"
then the field "DateOfCancellation" can not be null.
Is there a way to automatically enforce constraints on the row or column
change events?
Click to expand...
I might not be such a good idea...
 
Back
Top