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

yagnesh_shah_at_hotmail.com (Yogi) wrote:
> 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.

Are there LOBs in the table? I vaguely recall something about drivers inserting rows first without LOBs, getting the LOB locators, then going back and updating the row with the LOB information. So what looks like a single update statement actually is an insert and an update. So exclude any LOB columns from the update trigger, and see what happens.

Just a thought.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service              New Rate! $9.95/Month 50GB