Re: Check constraint violated

Ed Prochak wrote:

> Where did I say front end client? Application layer really isn't the right
> term, but my point was his rule could not be done in a check constraint!

Ah.. get your terminology right Ed and you will prevent me from foaming at the mouth.

(Application layer = front-end) in my mind.

>> Enforcing business rules in client software IS *STUPID*. Period.
>
> I did suggest that since he ALREADY had coded the rule in his front end,
> that he might leave it there for now.

Ah.. but you should have insulted his choice in architecture in the same breath. As you did not, he likely thinks he made the right decision. :-)

> Not the greatest choice, but the
> code already exists. He can add rules enforcement to the DB later and
> eventually remove this check in the front end.

In my experience, that type of thing _never_ happens. Reason. It works. Kind of. So never mind how inflexible and problematic it is.. it works so it stays as is. I have first hand experience of this. And loads of it. And then the DBA or developer doing the maintanence sit with The Problem.. because some dork has no idea on how to *correctly* use client-server architecture.

>> I sometimes wonder if there are only a few of us here that actually work
>> in the friggen REAL WORLD.
>>
>> Or else you guys must be smoking something. If so.. please pass some
>> along my way.
>
> Chill out.

Only if you pass whatever your smoking/drinking.

Or are you telling me that dealing with crap like this in the real world on mission critical systems are fine? That having to work till the wee hours of the morn because of crap designs and development, is fine? (how many of these have you pulled recently Ed?)

Sorry, but I can not let go of the old and trusted lead pipe when I run into people who still insist on coding and designing crap. Or when people ignore this crap and pretend that is fine designing and developing that way.

<humming>
I have a lead pipe
  and I'm okay
I like beating crap
  outta dorks everyday..

(chorus anyone?)

--
Billy