Re: HELP with TRIGGER

Dickson Lukose (lukose_at_neumann.une.edu.au) wrote:
> CREATE TRIGGER a2Nulify
> BEFORE DELETE ON OPS$NEURAL.a3
> FOR EACH ROW
> BEGIN
> UPDATE OPS$NEURAL.a4
> set OPS$NEURAL.a4.CUSTOMER_NUMBER = NULL
> where a3.customer_number = a4.customer_number;

• try changing to where OPS$NEURAL.a3.customer_number = OPS$NEURAL. a4.customer_number;
  > END;
  

--
**************************************************************
*                          Saad Ahmad                        *
*                          McHugh Freeman & Associates, Inc. *
*                          Ph:  (414) 798-8606 Ext. 457      *
*                          Fax: (414) 798-8619               *
*                          E-Mail: sahmad_at_mfa.com            *
**************************************************************