Re: Trigger programme without a trigger.

[David Gibbs <david@xxxxxxxxxxxx>]

Joe Pluta wrote:
> You say you want to implement triggers to make it easy to update data 
> errors without making more data errors.  I ask you: if you had triggers, 
> how did you get data errors?  If the triggers allowed the data errors in 
> the first place, then they will allow more!  So why do you have the 
> triggers?

The point of the trigger is to avoid the data errors.  If the triggers 
are not there, then the data can contain errors.  The triggers are put 
in place to prevent the data errors.

If you are relying entirely on system security and an io module to 
enforce your business rules, then someone with sufficient authority CAN 
casually violate the business rules by updating the data directly.  A 
trigger prevents that by enforcing the business rules when the data is 
updated ... regardless of how it's updated.

Yes, that same person could (theoretically) remove the trigger and 
perform the update ... but that's not a casual operation.

david