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.

Trigger use

3 posts in Trigger Last posting was on 2004-01-23 12:25:02.0Z
"Gabri?l vd Kruijk" <gabriel[asdfasdf]{asdfasdf) Posted on 2004-01-23 08:46:41.0Z
From: "Gabri?l vd Kruijk" <gabriel[asdfasdf]{asdfasdf)@spammers.zijn.dwazen(marti.nl)>
Newsgroups: Advantage.Trigger
Subject: Trigger use
Date: Fri, 23 Jan 2004 09:46:41 +0100
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 62.45.153.247
Message-ID: <4010fc2b@solutions.advantagedatabase.com>
X-Trace: 23 Jan 2004 03:49:15 -0700, 62.45.153.247
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!62.45.153.247
Xref: solutions.advantagedatabase.com Advantage.Trigger:21
Article PK: 1136091

Hi,

Since I woulde like to be able to capture every event that happens on my
ADD, I was wondering what's the best approach?

I could create INSERT / UPDATE AND DELETE, before, instead off and after
events for each and every table, or is there a better way?

Or should I put this al in to my code, instead of using triggers? (Maybe I'm
missing the purpose / best practice) of using triggers)

Anyone any suggestions?

Greets,
Gab


Joachim Duerr (ADS Support) Posted on 2004-01-23 10:53:15.0Z
From: "Joachim Duerr (ADS Support)" <jojo.duerr@gmx.de>
Subject: Re: Trigger use
Newsgroups: Advantage.Trigger
References: <4010fc2b@solutions.advantagedatabase.com>
Organization: Extended Systems GmbH
User-Agent: XanaNews/1.15.8.5
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 195.2.185.25
Message-ID: <4010fd1b@solutions.advantagedatabase.com>
Date: 23 Jan 2004 03:53:15 -0700
X-Trace: 23 Jan 2004 03:53:15 -0700, 195.2.185.25
Lines: 23
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!195.2.185.25
Xref: solutions.advantagedatabase.com Advantage.Trigger:22
Article PK: 1136092


Gabri?l vd Kruijk wrote in <4010fc2b@solutions.advantagedatabase.com> :

> Since I woulde like to be able to capture every event that happens on
> my ADD, I was wondering what's the best approach?
>
> I could create INSERT / UPDATE AND DELETE, before, instead off and
> after events for each and every table, or is there a better way?
>
> Or should I put this al in to my code, instead of using triggers?
> (Maybe I'm missing the purpose / best practice) of using triggers)

If you run a SQL Statement (Update ...), it's impossible for your
application to track all database changes. So the best way will be the
trigger.
Check the Advantage.Announcements NG: Thomas ported the IB Logmanager
to ADS. This exactly the tool you need.

--
Joachim Duerr
EMEA Lead ADS Support, Extended Systems GmbH, Germany
advantage[AT]extendsys.de
European Advantage Conference 2004:
http://makeashorterlink.com/?M20712907


Thomas Steinmaurer Posted on 2004-01-23 12:25:02.0Z
From: "Thomas Steinmaurer" <ts@iblogmanager.com>
Newsgroups: Advantage.Trigger
References: <4010fc2b@solutions.advantagedatabase.com>
Subject: Re: Trigger use
Date: Fri, 23 Jan 2004 13:25:02 +0100
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 140.78.93.2
Message-ID: <401113c7@solutions.advantagedatabase.com>
X-Trace: 23 Jan 2004 05:29:59 -0700, 140.78.93.2
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!140.78.93.2
Xref: solutions.advantagedatabase.com Advantage.Trigger:23
Article PK: 1136094

Gab,

> Since I woulde like to be able to capture every event that happens on my
> ADD, I was wondering what's the best approach?
>
> I could create INSERT / UPDATE AND DELETE, before, instead off and after
> events for each and every table, or is there a better way?
>
> Or should I put this al in to my code, instead of using triggers? (Maybe
I'm
> missing the purpose / best practice) of using triggers)
>
> Anyone any suggestions?

If you don't want to lookup Joachim's suggestion in the Announcement
group, then simply go here: http://www.adslogmanager.com

Best Regards,
Thomas Steinmaurer

Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com
Logging/Auditing Suite for Advantage Database Server
http://www.adslogmanager.com