Re: Check constraint violated

Originally posted by Ed Prochak
> andrewst wrote in message news:news:...
> > 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

None taken! I know how easy it is for a well-meant response to be taken badly and escalate into a grudge match. I suppose that's why we need to keep smiling and winking like this ;)

--
Posted via http://dbforums.com