Insert & Update triggers fire together when a new record is created.

Giganews Newsgroups
Subject: Insert & Update triggers fire together when a new record is created.
Posted by:  yagnesh_sh…@hotmail.com
Date: 27 Dec 2002

Hi,

I have two triggers, one when an insert is performed and the other
when an update is performed. I use these triggers to synchronize two
billing systems. So when a new account is created I update a temp
table with a tag of 'NEW' and when a account is modified I send it
with a tag of 'CHG'. But I create a new record both of the triggers
fire and I get both the tags 'NEW' and 'CHG' in my temp table. Is
there a way I could avoid this only when I am creating new accounts. I
would be grateful if someone could help me. Thanks in advance.

Thanks
Yogi

Replies