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.

Viewing replication log from an application?

7 posts in Replication Last posting was on 2004-01-23 12:54:39.0Z
Snezana Posted on 2004-01-21 17:24:32.0Z
From: Snezana <fox@micromax.co.yu>
Newsgroups: Advantage.Replication
Subject: Viewing replication log from an application?
Date: Wed, 21 Jan 2004 18:24:32 +0100
Message-ID: <MPG.1a78d425acd95861989686@devzone.advantagedatabase.com>
Organization: Micromax
X-Newsreader: MicroPlanet Gravity v2.60
NNTP-Posting-Host: 194.106.189.62
X-Trace: 21 Jan 2004 10:29:08 -0700, 194.106.189.62
Lines: 8
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!194.106.189.62
Xref: solutions.advantagedatabase.com Advantage.Replication:61
Article PK: 1133920

After synchronization has accured is it possible to somehow 'see' which
records where updated, deleted or added to a specific table from within
an application (app is in written in Delphi) that is using that
database?

TIA

Snezana


Lee Stigile Posted on 2004-01-22 17:48:50.0Z
From: "Lee Stigile" <lees@extendsys.com>
Newsgroups: Advantage.Replication
References: <MPG.1a78d425acd95861989686@devzone.advantagedatabase.com>
Subject: Re: Viewing replication log from an application?
Date: Thu, 22 Jan 2004 10:48:50 -0700
Lines: 18
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: 192.168.30.82
Message-ID: <40100d71@solutions.advantagedatabase.com>
X-Trace: 22 Jan 2004 10:50:41 -0700, 192.168.30.82
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!192.168.30.82
Xref: solutions.advantagedatabase.com Advantage.Replication:63
Article PK: 1133923

I don't believe that there's a way to extract specific changes from the
replication server. You'd probably be better off using an Advantage
Database Trigger (BEFORE insert/update/delete) to create a change log.
Lee Stigile
ESI Support

"Snezana" <fox@micromax.co.yu> wrote in message
news:MPG.1a78d425acd95861989686@devzone.advantagedatabase.com...
> After synchronization has accured is it possible to somehow 'see' which
> records where updated, deleted or added to a specific table from within
> an application (app is in written in Delphi) that is using that
> database?
>
> TIA
>
> Snezana


Joachim Duerr (ADS Support) Posted on 2004-01-23 08:16:47.0Z
From: "Joachim Duerr (ADS Support)" <jojo.duerr@gmx.de>
Subject: Re: Viewing replication log from an application?
Newsgroups: Advantage.Replication
References: <MPG.1a78d425acd95861989686@devzone.advantagedatabase.com> <40100d71@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
NNTP-Posting-Host: 195.2.185.25
Message-ID: <4010d86f@solutions.advantagedatabase.com>
Date: 23 Jan 2004 01:16:47 -0700
X-Trace: 23 Jan 2004 01:16:47 -0700, 195.2.185.25
Lines: 16
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!195.2.185.25
Xref: solutions.advantagedatabase.com Advantage.Replication:65
Article PK: 1133921


Lee Stigile wrote in <40100d71@solutions.advantagedatabase.com> :

> I don't believe that there's a way to extract specific changes from
> the replication server. You'd probably be better off using an
> Advantage Database Trigger (BEFORE insert/update/delete) to create a
> change log.

you can't use a trigger since the tables are free tables and not data
dictionary bound:(

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


Snezana Lisica Posted on 2004-01-23 11:05:44.0Z
From: "Snezana Lisica" <fox@micromax.co.yu>
Subject: Re: Viewing replication log from an application?
Newsgroups: Advantage.Replication
References: <MPG.1a78d425acd95861989686@devzone.advantagedatabase.com> <40100d71@solutions.advantagedatabase.com> <4010d86f@solutions.advantagedatabase.com>
User-Agent: XanaNews/1.16.1.1
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 194.106.189.62
Message-ID: <40110008@solutions.advantagedatabase.com>
Date: 23 Jan 2004 04:05:44 -0700
X-Trace: 23 Jan 2004 04:05:44 -0700, 194.106.189.62
Lines: 33
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!194.106.189.62
Xref: solutions.advantagedatabase.com Advantage.Replication:66
Article PK: 1133924


Joachim Duerr (ADS Support) wrote:

> Lee Stigile wrote in <40100d71@solutions.advantagedatabase.com> :
>
> > I don't believe that there's a way to extract specific changes from
> > the replication server. You'd probably be better off using an
> > Advantage Database Trigger (BEFORE insert/update/delete) to create a
> > change log.

> you can't use a trigger since the tables are free tables and not data
> dictionary bound:(

Well, I do have free tables but I though that by putting them in a
dictionary and creating triggers on tables that I need to have log of
changes I can solve my problem, just like Lee suggested.

If replication is going through dictionary, than all triggers that are
defined on tables that are being synchronized _will_ 'trigger'.
Right?

--
Regards,
Snezana


Joachim Duerr (ADS Support) Posted on 2004-01-23 12:10:07.0Z
From: "Joachim Duerr (ADS Support)" <jojo.duerr@gmx.de>
Subject: Re: Viewing replication log from an application?
Newsgroups: Advantage.Replication
References: <MPG.1a78d425acd95861989686@devzone.advantagedatabase.com> <40100d71@solutions.advantagedatabase.com> <4010d86f@solutions.advantagedatabase.com> <40110008@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
NNTP-Posting-Host: 195.2.185.25
Message-ID: <40110f1f@solutions.advantagedatabase.com>
Date: 23 Jan 2004 05:10:07 -0700
X-Trace: 23 Jan 2004 05:10:07 -0700, 195.2.185.25
Lines: 20
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!195.2.185.25
Xref: solutions.advantagedatabase.com Advantage.Replication:67
Article PK: 1133925


Snezana Lisica wrote in <40110008@solutions.advantagedatabase.com> :

> Well, I do have free tables but I though that by putting them in a
> dictionary and creating triggers on tables that I need to have log of
> changes I can solve my problem, just like Lee suggested.
>
> If replication is going through dictionary, than all triggers that are
> defined on tables that are being synchronized will 'trigger'.
> Right?

right. I thought of the OB internal tables - my fault.
Yes - you can define a insert, update and a delete trigger to your
database tables and they will be fired.

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


Snezana Lisica Posted on 2004-01-23 12:54:39.0Z
From: "Snezana Lisica" <fox@micromax.co.yu>
Subject: Re: Viewing replication log from an application?
Newsgroups: Advantage.Replication
References: <MPG.1a78d425acd95861989686@devzone.advantagedatabase.com> <40100d71@solutions.advantagedatabase.com> <4010d86f@solutions.advantagedatabase.com> <40110008@solutions.advantagedatabase.com> <40110f1f@solutions.advantagedatabase.com>
User-Agent: XanaNews/1.16.1.1
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 194.106.189.62
Message-ID: <4011198f@solutions.advantagedatabase.com>
Date: 23 Jan 2004 05:54:39 -0700
X-Trace: 23 Jan 2004 05:54:39 -0700, 194.106.189.62
Lines: 23
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!194.106.189.62
Xref: solutions.advantagedatabase.com Advantage.Replication:68
Article PK: 1133926


Joachim Duerr (ADS Support) wrote:

> Snezana Lisica wrote in <40110008@solutions.advantagedatabase.com> :
>
> > Well, I do have free tables but I though that by putting them in a
> > dictionary and creating triggers on tables that I need to have log
> > of changes I can solve my problem, just like Lee suggested.
> >
> > If replication is going through dictionary, than all triggers that
> > are defined on tables that are being synchronized will 'trigger'.
> > Right?
>
> right. I thought of the OB internal tables - my fault.
> Yes - you can define a insert, update and a delete trigger to your
> database tables and they will be fired.

Thought so.

Thanks.

--
Snezana


"Thomas Steinmaurer" <ts Posted on 2004-01-22 20:14:58.0Z
From: "Thomas Steinmaurer" <ts@removespam_adslogmanager.com>
Newsgroups: Advantage.Replication
References: <MPG.1a78d425acd95861989686@devzone.advantagedatabase.com> <40100d71@solutions.advantagedatabase.com>
Subject: Re: Viewing replication log from an application?
Date: Thu, 22 Jan 2004 21:14:58 +0100
Lines: 21
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.227.125
Message-ID: <40102f3f@solutions.advantagedatabase.com>
X-Trace: 22 Jan 2004 13:14:55 -0700, 62.46.227.125
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!62.46.227.125
Xref: solutions.advantagedatabase.com Advantage.Replication:64
Article PK: 1133922

Hi there,

> I don't believe that there's a way to extract specific changes from the
> replication server. You'd probably be better off using an Advantage
> Database Trigger (BEFORE insert/update/delete) to create a change log.

One might consider using ADS LogManager for that, because it
makes the integration and maintenance of a change log a snap.
A 30 days trial download is available 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 7

http://www.adslogmanager.com