Re: Check constraint violated

andrewst <member14183_at_dbforums.com> wrote in message news:<3006312.1055756289_at_dbforums.com>...
> Originally posted by Ed Prochak
> > But it you already validated this, why add it to the DB? Likely you
> > intend to
> > remove the VB validation, but then you will have to add code to
> > handle bad
> > inserts (which return errors when the rule is violated).
> >
> Probably because enforcing business rules through the client only
> is bad practice and should be avoided if at all possible.

Agreed. But given that the OP already has this validation coded in the VB front end and then wanted to force this into a check constraint, I expected them not to understand suggestions about building rules tables and such. Maybe I underestimated their skills.

(Interesting the way threads go sometimes. You try to explain at a lower level and someone else at a higher level points out how you simplified too much! No offense andrew)

Ed Received on Mon Jun 16 2003 - 11:52:40 CDT