Re: When use triggers?

On Fri, May 18, 2018 at 12:45 PM, Melvin Davidson <melvin6925(at)gmail(dot)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(dot)tanzer(at)agency-software(dot)org
(253) 245-3801

Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.