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.

Transaction logging

6 posts in Xbase++ Last posting was on 2010-02-28 08:30:19.0Z
Ben Bodenstein Posted on 2010-02-11 20:41:46.0Z
From: Ben Bodenstein <ben@powerprop.co.za>
Subject: Transaction logging
Newsgroups: Advantage.Xbase++
User-Agent: 40tude_Dialog/2.0.15.1
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Organization: PowerProp Systems
Date: Thu, 11 Feb 2010 22:41:46 +0200
Message-ID: <18hnkn93mn6jq$.1eotfx6swfcs$.dlg@40tude.net>
NNTP-Posting-Host: 41.240.182.37
X-Trace: 11 Feb 2010 13:39:44 -0700, 41.240.182.37
Lines: 7
Path: solutions.advantagedatabase.com!41.240.182.37
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1105
Article PK: 1140939

Can ADS do logging on DBF files and if so, how do I activate it?
I want to be able to log every table's appends, edits and deletes with
username, date, time, etc.

Many thanks,
Ben


Joachim Duerr (ADS) Posted on 2010-02-12 08:17:50.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Transaction logging
Newsgroups: Advantage.Xbase++
References: <18hnkn93mn6jq$.1eotfx6swfcs$.dlg@40tude.net>
Date: Fri, 12 Feb 2010 09:17:50 +0100
User-Agent: XanaNews/1.19.1.194
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 130.214.79.11
Message-ID: <4b750e2f@solutions.advantagedatabase.com>
X-Trace: 12 Feb 2010 01:15:43 -0700, 130.214.79.11
Lines: 13
Path: solutions.advantagedatabase.com!130.214.79.11
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1106
Article PK: 1140940


Ben Bodenstein wrote:

>Can ADS do logging on DBF files and if so, how do I activate it?
>I want to be able to log every table's appends, edits and deletes with
>username, date, time, etc.

only when using a data dictionary. Free table's activities cannot be
logged by the server.

--
Joachim Duerr
Advantage Presales
check out my new ADS book on http://www.jd-engineering.de/adsbuch


Ben Bodenstein Posted on 2010-02-13 13:10:10.0Z
From: Ben Bodenstein <ben@powerprop.co.za>
Subject: Re: Transaction logging
Newsgroups: Advantage.Xbase++
User-Agent: 40tude_Dialog/2.0.15.1
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Organization: PowerProp Systems
References: <18hnkn93mn6jq$.1eotfx6swfcs$.dlg@40tude.net> <4b750e2f@solutions.advantagedatabase.com>
Date: Sat, 13 Feb 2010 15:10:10 +0200
Message-ID: <1d6sf763qh6c8.179hd4ielfx5u.dlg@40tude.net>
NNTP-Posting-Host: 41.240.162.117
X-Trace: 13 Feb 2010 06:08:07 -0700, 41.240.162.117
Lines: 37
Path: solutions.advantagedatabase.com!41.240.162.117
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1107
Article PK: 1140941

Thank you, Joachim.
How do I open a DBF after having connected to ADD?
Witout the data dictionary I can open DBF's like this:

For every new thread I connect:

cServer := UPPER(CurDrive()+':')
oDac := dacSession():New(cSession)

and then using oDac as the session to open a DBF:
USE (cDbf) VIA oDac

This works on free tables, but when connecting to the data dictionary, I
get an error on opening a DBF:

cDict := "c:\apps\data\TestData.add"
cSession := "DBE=ADSDBE;SERVER=" + cDict + ';UID=' + cUser
+';PWD='+cPassword
oDac := dacSession():New(cSession)
USE (cDbf) VIA oSession

Where am I going wrong?

Thanks,
Ben

On Fri, 12 Feb 2010 09:17:50 +0100, Joachim Duerr (ADS) wrote:

> Ben Bodenstein wrote:
>
>>Can ADS do logging on DBF files and if so, how do I activate it?
>>I want to be able to log every table's appends, edits and deletes with
>>username, date, time, etc.
>
> only when using a data dictionary. Free table's activities cannot be
> logged by the server.


Mark Wilkins Posted on 2010-02-23 16:35:04.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: Advantage.Xbase++
References: <18hnkn93mn6jq$.1eotfx6swfcs$.dlg@40tude.net> <4b750e2f@solutions.advantagedatabase.com>
Subject: Re: Transaction logging
Date: Tue, 23 Feb 2010 09:35:04 -0700
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: 10.24.38.228
Message-ID: <4b840339@solutions.advantagedatabase.com>
X-Trace: 23 Feb 2010 09:32:57 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1108
Article PK: 1140942

It's probably worth pointing out that ADS does not perform transaction
logging automatically; that functionality is not built in to the server.
Joachim might be referring to the capability of adding triggers to the
tables to do this. And triggers do require the use of a data dictionary.
Hopefully Joachim can elaborate a little bit on his answer.

You might also take a look at the ADS LogManager (http://www.upscene.com).
It is a third-party product that provides this capability.

Mark Wilkins
Advantage R&D

"Joachim Duerr (ADS)" <jojo.duerr@gmx.de> wrote in message
news:4b750e2f@solutions.advantagedatabase.com...
> Ben Bodenstein wrote:
>
>>Can ADS do logging on DBF files and if so, how do I activate it?
>>I want to be able to log every table's appends, edits and deletes with
>>username, date, time, etc.
>
> only when using a data dictionary. Free table's activities cannot be
> logged by the server.
>
> --
> Joachim Duerr
> Advantage Presales
> check out my new ADS book on http://www.jd-engineering.de/adsbuch


Joachim Duerr (ADS) Posted on 2010-02-23 17:08:25.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Transaction logging
Newsgroups: Advantage.Xbase++
References: <18hnkn93mn6jq$.1eotfx6swfcs$.dlg@40tude.net> <4b750e2f@solutions.advantagedatabase.com> <4b840339@solutions.advantagedatabase.com>
Date: Tue, 23 Feb 2010 18:08:25 +0100
User-Agent: XanaNews/1.19.1.194
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 84.158.164.27
Message-ID: <4b840b00@solutions.advantagedatabase.com>
X-Trace: 23 Feb 2010 10:06:08 -0700, 84.158.164.27
Lines: 20
Path: solutions.advantagedatabase.com!84.158.164.27
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1109
Article PK: 1140944


Mark Wilkins wrote:

>It's probably worth pointing out that ADS does not perform
>transaction logging automatically; that functionality is not built in
>to the server. Joachim might be referring to the capability of adding
>triggers to the tables to do this. And triggers do require the use
>of a data dictionary. Hopefully Joachim can elaborate a little bit on
>his answer.
>
>You might also take a look at the ADS LogManager
>(http://www.upscene.com). It is a third-party product that provides
>this capability.

Mark's right...but ojne addition: AdsLogManager requires the use of a
data dictionary since it creates triggers for the logging.

--
Joachim Duerr
Advantage Presales
check out my new ADS book on http://www.jd-engineering.de/adsbuch


Ben Bodenstein Posted on 2010-02-28 08:30:19.0Z
From: Ben Bodenstein <ben@powerprop.co.za>
Subject: Re: Transaction logging
Newsgroups: Advantage.Xbase++
User-Agent: 40tude_Dialog/2.0.15.1
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Organization: PowerProp Systems
References: <18hnkn93mn6jq$.1eotfx6swfcs$.dlg@40tude.net> <4b750e2f@solutions.advantagedatabase.com> <4b840339@solutions.advantagedatabase.com> <4b840b00@solutions.advantagedatabase.com>
Date: Sun, 28 Feb 2010 10:30:19 +0200
Message-ID: <qpqjn3x7g44h$.orxyy1ww4bnb$.dlg@40tude.net>
NNTP-Posting-Host: 41.240.141.33
X-Trace: 28 Feb 2010 01:28:11 -0700, 41.240.141.33
Lines: 31
Path: solutions.advantagedatabase.com!41.240.141.33
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1110
Article PK: 1140943

Thanks for the info guys. I downloaded a demo version of AdsLogManager from
Upscene and I got it going, except that I can not get the primary key or
record number to be logged as well.
If I want to capture Adds for a transactions file, I need to know exactly
which record was added by whom. Also on a master clients file I need the
unique client number to be logged. I notice there are primary keys fields
in AdsLogManager, but how do I get the primary keys there?

Any help on this will be appreciated.

Ben

On Tue, 23 Feb 2010 18:08:25 +0100, Joachim Duerr (ADS) wrote:

> Mark Wilkins wrote:
>
>>It's probably worth pointing out that ADS does not perform
>>transaction logging automatically; that functionality is not built in
>>to the server. Joachim might be referring to the capability of adding
>>triggers to the tables to do this. And triggers do require the use
>>of a data dictionary. Hopefully Joachim can elaborate a little bit on
>>his answer.
>>
>>You might also take a look at the ADS LogManager
>>(http://www.upscene.com). It is a third-party product that provides
>>this capability.
>
> Mark's right...but ojne addition: AdsLogManager requires the use of a
> data dictionary since it creates triggers for the logging.