Thanks for that detailed explanation. It happily came right as I was
composing an e-mail stating that closing the cursors failed to release the
OAT :)

The method for 3.6 was TIB_Connection.CloseTransactions, and it was the
transaction in the schema cache that was staying open.


Thanks again for your detailed assistance in this matter.


Bill M

-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: Tuesday, October 23, 2001 11:19 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Threaded transaction not advancing - Additional
Detail


Bill,

> I didn't realize that an open cursor would keep an open transaction
> regardless of explicit commits of it's transaction.

An explicit Commit will override any open cursors. They should be forced to
be closed if you call the Commit method of their transaction.

I think you are getting hung up by the transaction in the schema cache.
Please read carefully the additional clarifications I sent a minute or two
ago.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com



___________________________________________________________________________
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 !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/