Re: "We don't do triggers"

Mike Sherrill wrote:

> On Tue, 25 Nov 2003 08:35:23 -0500, "mcstock"
> <[EMAIL PROTECTED]> wrote:
>
>
> > if you're referring to declarative constraints, that's a given 
>
>
> I'm pretty sure that most of the people posting to this thread don't
> regard it as a given.  
>
> Looks like it's time to clarify who means what when they're talking
> about "business logic" and "integrity constraints".  To me, it looks
> like some people regard them as identical, and some people regard them
> as different.

By any definition you will ever learn while earning a computer science 
degree they are different.

The business logic is that every invoice must have an invoice number.
The integrity constraint is a primary key.

The business logic is that all persons must have a gender
The integrity constraints are a NOT NULL and a check constraint 
constraining entries to 'F' or 'M').
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
[EMAIL PROTECTED]
(replace 'x' with a 'u' to reply)