Subject Re: [IBO] Threaded transaction not advancing
Author Jason Wharton
If you are using a TIB_Cursor are you making sure they get closed? IBO
doesn't do anything automatic when you are using a unidirectional cursor.
This is something you have to manually take care to use.

Are you checking the Started property of the transaction to determine that
it is ended? All transactions should be visible in the array of

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "Bill Morrison" <bmorrison@...>
To: <>
Sent: Tuesday, October 23, 2001 9:11 AM
Subject: [IBO] Threaded transaction not advancing

> I'm having a weird problem with 3.6.Dg running against IB 5.6.
> I have a datamodule that I am creating in a thread. This datamodule has a
> TIB_Connection component, to TIB_Transactions (tiCommitted), and some
> and dsql components.
> Now, if this datamodule is created outside of the thread (I was
> inadvertantly creating it in the thread's constructor (main thread
> context)), then everything runs fine, and the transactions advance
> However, once I started creating the datamodule in the threads execute
> method, the OAT and OIT will cease advancing on the server.
> All of the cursors and dsql are connected to one or the other
> and the transactions are committing every ten seconds or so. Even manually
> setting a breakpoint and committing them in debug mode will not increment
> the OAT and OIT.
> Interestingly, if I look at the transactioncount property of the
> TIB_Transaction, it returns 3. I thus assume that the third transaction is
> being created internally for some IBO internal housekeeping, and is for
> reason not incrementing it's OAT.
> Any assistance with this problem would be greatly appreciated!
> Bill Morrison
> IB Objects - direct, complete, custom connectivity to Firebird or
> without the need for BDE, ODBC or any other layer.
> - your IBO community resource for Tech Info
> keyword-searchable FAQ, community code contributions and more !
> Your use of Yahoo! Groups is subject to