Triggers and RI

[rbbaird@xxxxxxxxxxx (Rick Baird)]

howdy all,

It's my understanding that if you have set up your database for
Referential Integrity, that if you try to add or change a "child" file
that breaks those RI rules, and if there is also a trigger program
attached to the child, the trigger progam is executed, whether or not
the record updat/write is successful.  

My question is this:   Is there anyway (short of chaining to the parent
to verify) for the trigger to know if RI rules were broken, thus
disallowing the update, so that the trigger won't process stuff that
depends on the update having been successful?

Does this make any sense?  I mean, if you have to have your trigger
program do it's own checking to verify RI, why have RI at the database
level?

Just wondering,

Thanks in advance

Rick
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *