Subject Re: [ib-support] Connect to DB from Procedure ??
Author Ivan Prenosil
> I need the logging to be independent of the program, to log all reads,
> updates, etc from all programs. One of the requirements is the logging of
> what was read by a user even when they are using a 3rd party reporting tool.

- if you need to log reads, you have to use stored procedures, because there are no select-triggers

- you need to use transaction independent method (such as UDF, or better yet external files);
otherwise user can read whole database and then just finish with Rollback,
and your log will remain empty!

Ivan
prenosil@...
http://www.volny.cz/iprenosil/interbase