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

Giganews Newsgroups
Subject: Re: Insert & Update triggers fire together when a new record is created.
Posted by:  Jim Kennedy (kennedy-fami…@attbi.com)
Date: Fri, 27 Dec 2002

It shouldn't.  Can you post the trigger code for both?
Jim
"Yogi" <yagnesh_sh…@hotmail.com> wrote in message
news:272bd3a7.0212270422.424176…@posting.google.com...
> 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

None

In response to

Insert & Update triggers fire together when a new record is created. posted by yagnesh_sh…@hotmail.com on 27 Dec 2002