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.

How can I determine if a trigger is row-level or global?

4 posts in Trigger Last posting was on 2006-11-07 13:16:21.0Z
Paul Man Posted on 2006-11-06 19:45:42.0Z
From: "Paul Man" <paulman@datasoft.ie>
Newsgroups: advantage.trigger
Subject: How can I determine if a trigger is row-level or global?
Date: Mon, 6 Nov 2006 19:45:42 -0000
Lines: 4
Organization: DSoft
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
NNTP-Posting-Host: 82.141.233.142
Message-ID: <454f900f@solutions.advantagedatabase.com>
X-Trace: 6 Nov 2006 12:42:07 -0700, 82.141.233.142
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.141.233.142
Xref: solutions.advantagedatabase.com Advantage.Trigger:280
Article PK: 1136345

Is it possible to define a trigger for row-level for individual record
operations or for global defintion?


"Alex Wong \(ADS\)" <alexw Posted on 2006-11-06 20:46:15.0Z
From: "Alex Wong \(ADS\)" <alexw@*n_o__s_p_a_m*sybase.com>
Newsgroups: advantage.trigger
References: <454f900f@solutions.advantagedatabase.com>
Subject: Re: How can I determine if a trigger is row-level or global?
Date: Mon, 6 Nov 2006 13:46:15 -0700
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
NNTP-Posting-Host: 10.24.38.183
Message-ID: <454f9e16@solutions.advantagedatabase.com>
X-Trace: 6 Nov 2006 13:41:58 -0700, 10.24.38.183
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.183
Xref: solutions.advantagedatabase.com Advantage.Trigger:282
Article PK: 1136348

Can you clarify the question?

"Paul Man" <paulman@datasoft.ie> wrote in message
news:454f900f@solutions.advantagedatabase.com...
> Is it possible to define a trigger for row-level for individual record
> operations or for global defintion?
>


Thomas Steinmaurer Posted on 2006-11-07 06:42:05.0Z
Date: Tue, 07 Nov 2006 07:42:05 +0100
From: Thomas Steinmaurer <t.steinmaurer_dontbugmewithspam@upscene.com>
User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
MIME-Version: 1.0
Newsgroups: advantage.trigger
Subject: Re: How can I determine if a trigger is row-level or global?
References: <454f900f@solutions.advantagedatabase.com>
In-Reply-To: <454f900f@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 193.186.164.88
Message-ID: <455029b3@solutions.advantagedatabase.com>
X-Trace: 6 Nov 2006 23:37:39 -0700, 193.186.164.88
Lines: 20
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!193.186.164.88
Xref: solutions.advantagedatabase.com Advantage.Trigger:284
Article PK: 1136351

Paul,

> Is it possible to define a trigger for row-level for individual record
> operations or for global defintion?

ADS supports row-level triggers, that said, the trigger fire for each
manipulated record. There isn't something like statement-level triggers
(as in MSSQL) or database/system triggers in ADS.

To be honest, I don't miss statement-level triggers at all. ;-)


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com


Paul Man Posted on 2006-11-07 13:16:21.0Z
From: "Paul Man" <paulman@datasoft.ie>
Newsgroups: advantage.trigger
References: <454f900f@solutions.advantagedatabase.com> <455029b3@solutions.advantagedatabase.com>
Subject: Re: How can I determine if a trigger is row-level or global?
Date: Tue, 7 Nov 2006 13:16:21 -0000
Lines: 27
Organization: DSoft
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
NNTP-Posting-Host: 82.141.233.142
Message-ID: <4550864c@solutions.advantagedatabase.com>
X-Trace: 7 Nov 2006 06:12:44 -0700, 82.141.233.142
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.141.233.142
Xref: solutions.advantagedatabase.com Advantage.Trigger:285
Article PK: 1136350

That's what I wanted to clarify - that the triggers are always fired for
each record and that __new only contains one record.

"Thomas Steinmaurer" <t.steinmaurer_dontbugmewithspam@upscene.com> wrote in
message news:455029b3@solutions.advantagedatabase.com...
> Paul,
>
>> Is it possible to define a trigger for row-level for individual record
>> operations or for global defintion?
>
> ADS supports row-level triggers, that said, the trigger fire for each
> manipulated record. There isn't something like statement-level triggers
> (as in MSSQL) or database/system triggers in ADS.
>
> To be honest, I don't miss statement-level triggers at all. ;-)
>
>
> --
> Best Regards,
> Thomas Steinmaurer
> LogManager Series - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database, MS SQL Server and
> NexusDB V2
> Upscene Productions
> http://www.upscene.com