>What do you mean by data abstraction layer?

That probably means no then. If your application runs queries against
the database directly, you have little control over it, and it means
that client programs need to be upgraded every time you make a change.

There are products (such as RemObjects) that allow you to create a
service that runs on the server that your client programs can talk to.

So I might have a function

function ChangeEmployeeName(const UserName : String; const Password :
String; const ID : Integer; const Name : String) : Boolean;

Instead of the client program running a update statement, they simply
call the function through the Remobjects (or equivalent) interface.

This allows you to scale easier and you can then keep your database
totally isolated. This layer also deals with compression and over the
wire data encryption.

As you can see, it would not be hard to modify ChangeEmployeeName to
log what it is being asked to do.


what 3rd party tools you

> r talking about?

www.upscene.com
have a Log Manager product that might be of interest.