RE: triggers within commit cycles

> >Why not use referential integrity to enforce business rules?
> >
>
> You can and should, but RI enforces a limited set of business rules. Rules
> like "a customer must exist before we can create an order" is an RI rule,
> but a rule like "send notification to a vendor whenever on-hand quantity
> falls below low-stock-point or reorder-point" is a trigger type rule.
>

Ok, I agree completely with this, and is what I do.  I thought the
discussion was about using triggers to ensure only 'A' or 'B' was allowed
for a given field.

Phil


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com