Can a trigger be used to cancel an update or delete?  If so, how?

Thanks,

Dale

Dale,

<< Can a trigger be used to cancel an update or delete?  If so, how? >>

Yep, just use the RAISE statement to raise an EXCEPTION from inside of a
BEFORE UPDATE or BEFORE DELETE trigger, and that will interrupt the update
or delete and return the error.

--
Tim Young
Elevate Software
www.elevatesoft.com