× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. August 2001

RE: triggers within commit cycles

>If I update a record in a file that has an update
>trigger, then rollback the transaction using
>commitment control, does the trigger program
>fire again with the correct update that puts the
>record back like it was?

Based on Bruce's answers, I need to do some testing!  I'm not sure when the
trigger fires; at HLL "UPDATE" time or at COMMIT time.  Either way, I
thought that a ROLLBACK would fire the "opposite" trigger; i.e. if the
record was added, the delete trigger would fire.  I MUST do some testing!

Buck

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2025 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.