On Fri, May 18, 2018 at 12:45 PM, Melvin Davidson <melvin6...@gmail.com> 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>* ken.tan...@agency-software.org (253) 245-3801 Subscribe to the mailing list <agency-general-requ...@lists.sourceforge.net?body=subscribe> to learn more about AGENCY or follow the discussion.