Re: Trigger novice needs help

Hi Chuck,

Mutating table problems are caused by row level triggers. Try using a statement trigger instead of using "FOR EACH ROW" if you need this trigger to fire for a transaction. I hope this helps.

Ryan

     Ryan S. Walcott
     Metasys, Inc.                   internet: rwalcott_at_metasys.com
     4600 Park Road
     Suite 280
     Charlotte, NC 28209

     "Keep thy heart with all diligence, for out of it spring the issues
     of life."       Proverbs  4:23


-------------------------------------------------------------------------------