Re: Check constraint violated

On Mon, 16 Jun 2003 19:26:19 +0000, andrewst wrote:

>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 ;)

Ed is right in his place as he meant to be helping a college student who did not properly understand the check constraint. You are right in your way, giving general guidelines of validating input. 8-)

Thanks a lot to both.

-- 
somebudy_at_despammed.com
The mail id is valid and not mangled.