Subject TIB_StoredProc, am I using it correctly?
Author B.D.S. Bell
Hi all,

This all seems very basic stuff, but I'm having a
significant problem with aa mem leak that's driving me
nuts. Any help will be much appreciated.

I have been using TIB_StoredProc for some time in an
application and it works fine, but recently on a smaller PC
Win98, only 64mb, there appears to be a memory leak. I've
checked all my objects Create /Destroy and all looks ok.
I'm using the NT Performance monitor, set to monitor Process
MyProcess Private Bytes, which with each invocation of the
object containing the TIB_StoredProc uses more mem and
appears not to return any on destroy.

In object create I've called SQLRead :=
TIB_StoredProc.Create( Messagecn );
and in the destructor SQLRead.Free;
where Messagecn is the connection created once at startup of
the application.

I prepare the SQL each time before execution (ExecProc) .

I start /stop the transaction with ,
with MessageTrn do
if not InTransaction then StartTransaction;

MessageTrn.Commit;

Is there anything else I need to do before SQLRead.Free?


Delphi 5 Enterprise
NT 4 SP 6
IBO V3.6 Ba

Thanks,

Bryan

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