Subject RE: [firebird-support] Re: Using an external table for logging
Author Nigel Weeks
It's a common approach, and works very well, especially for development of
stored procedures, where you can insert tracemarkers into the log table, and
even if the SP fails, the trace is still there, so you can see where in your
code it failed.


Nigel Weeks

Tech Support and Systems Developer

Rural Press Tasmania

The Examiner Newspaper

Ph. 03 6336 7234

Mob. 0408 133 738

Email. <mailto:nweeks@...> nweeks@...


[] On Behalf Of mspencewasunavailable
Sent: Thursday, 7 June 2007 9:07 AM
Subject: [firebird-support] Re: Using an external table for logging

--- In firebird-support@ <>, "robertgilland"
<robert_gilland@...> wrote:
> Yes there is a major problem there.
> Once Firebird opens an external file.
> Nothing other than Firebird can write to it.
> You want Firebird to log to the external table,
> but you probably want your delphi app to write
> to the table as well.
> Firebird will not allow this, unfortunately.

Well, no, I wanted Firebird to do the writing. The
apps would do inserts to the table instead of writing
to the file, which is better because (1) the log data
is consolidated and (2) the log data's not on the
user's machine where they can misplace or corrupt it.

Using a regular table for this kind of logging is often
not suitable because the log data can get rolled back;
an external table doesn't have that problem. I was
wondering if anyone else had tried this before.

Michael D. Spence
Mockingbird Data Systems, Inc.

[Non-text portions of this message have been removed]