Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Why AFTER Trigger doesn't fire when an INSTEAD OF trigger exists?

2 posts in Trigger Last posting was on 2003-11-06 22:20:15.0Z
Thomas Steinmaurer Posted on 2003-11-03 23:56:40.0Z
From: "Thomas Steinmaurer" <ts@iblogmanager.com>
Newsgroups: Advantage.Trigger
Subject: Why AFTER Trigger doesn't fire when an INSTEAD OF trigger exists?
Date: Tue, 4 Nov 2003 00:56:40 +0100
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
NNTP-Posting-Host: 62.46.232.50
Message-ID: <3fa6ebe1@solutions.advantagedatabase.com>
X-Trace: 3 Nov 2003 16:59:29 -0700, 62.46.232.50
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!62.46.232.50
Xref: solutions.advantagedatabase.com Advantage.Trigger:8
Article PK: 1136075

Hi there,

is there a specific reason why an AFTER trigger doesn't fire if
there exists an INSTEAD OF trigger for the same table? That
would make the AFTER trigger for logging purposes useless,
right?


Thank you,
Thomas


Jeremy D. Mullin Posted on 2003-11-06 22:20:15.0Z
From: Jeremy D. Mullin <IHateSpamjeremym@extendsys.com>
Newsgroups: Advantage.Trigger
Subject: Re: Why AFTER Trigger doesn't fire when an INSTEAD OF trigger exists?
Date: Thu, 6 Nov 2003 15:20:15 -0700
Message-ID: <MPG.1a14770a6bae3132989bdc@solutions.advantagedatabase.com>
References: <3fa6ebe1@solutions.advantagedatabase.com>
Organization: ESI
X-Newsreader: MicroPlanet Gravity v2.30
NNTP-Posting-Host: 198.60.232.45
X-Trace: 6 Nov 2003 15:25:35 -0700, 198.60.232.45
Lines: 27
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.60.232.45
Xref: solutions.advantagedatabase.com Advantage.Trigger:9
Article PK: 1136079

Hi Thomas,

Yeah. Once an INSTEAD OF trigger is fired the __old and __new values
aren't semantically valid, because we have no idea what the INSTEAD OF
trigger did.
In theory we could fire the AFTER triggers, but there would be no
guarantee that the __old and __new values are still correct, or that the
INSTEAD OF trigger didn't modify them directly.

J.D. Mullin
Advantage R&D

In article <3fa6ebe1@solutions.advantagedatabase.com>,
ts@iblogmanager.com says...

> Hi there,
>
> is there a specific reason why an AFTER trigger doesn't fire if
> there exists an INSTEAD OF trigger for the same table? That
> would make the AFTER trigger for logging purposes useless,
> right?
>
>
> Thank you,
> Thomas
>
>
>