Chuck,

The IBO SQL monitor doesn't produce a file. If a file is produced it is in
your own code. If you are using the TIB_LogFiles object that is part of IBO
then it won't ever overwrite anything. It only creates files and appends to
them. There is a way that you can dump your own custom information to the
SQL trace in order to work on profiling and tracing program details better.
You have to turn on Client Tracing and in your application you call the
TIB_Session OutputToMonitor method. (I hope I remembered the correct
spelling.)

Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Chuck Belanger
Sent: Monday, January 7, 2013 1:45 PM
To: IBObjects Listserve
Subject: [IBO] SQL Monitor?

Hi, Jason:

I have an SQL Monitor being enabled and then disabled in my code where I
am trying to troubleshoot a nasty but intermittent problem.

When SQL monitor is enabled, does it write over the existing file or
append to it, assuming the same file name?

I would like to also save to that file the current status of a few
variables. Is that possible based on what you do with that file with
your code?

Thanks,

Chuck Belanger


------------------------------------

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links