On Fri, May 18, 2018 at 12:45 PM, Melvin Davidson <[email protected]> wrote:
> > > > I have used triggers to keep audit-logs of changes to certain columns in > a table > Another good use for triggers is to maintain customer balance..EG: An > INSERT, UPDATE or DELETE involving a customer payment > (or in the case of banks (deposit or withdrawals) would automatically > maintain the balance in the customer master record. > > Another scenario is if you want to put a (check) constraint on your table that refers to other rows or tables. You can't actually do that, and need to use a trigger instead. -- AGENCY Software A Free Software data system By and for non-profits *http://agency-software.org/ <http://agency-software.org/>* *https://demo.agency-software.org/client <https://demo.agency-software.org/client>* [email protected] (253) 245-3801 Subscribe to the mailing list <[email protected]?body=subscribe> to learn more about AGENCY or follow the discussion.
