|
Kahn, David wrote: > You're on the right lines, but the situation is a bit more sophisticated > than that. Firstly, if you have the most basic RI constraint, the RESTRICT > rule, then the referential constraints are evaluated before an "after" > trigger is called. If they're violated the update is prevented and the > "after" trigger does not get called, although a "before" trigger would be. I'm asking this question for someone else, without knowing the full details. But he did tell me that it is a "before" trigger, so he must be using something other than RESTRICT for his ri. > The RI rules other than RESTRICT require you to be running under commitment > control. You should therefore ensure that all files involved in the > constraint and the trigger are running under the same commitment definition. This must be the hole in his boat. Thanks for the info! regards, 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 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.