Transaction logging

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.

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