Subject Re: [IBO] Database growth
Author Geoff Worboys
> Drop a TIB_SessionProps component onto your mainform. Check the
> TimerInterval property - make sure it is not zero! If it is zero set
> it to 2000 or 5000 in order to activate transaction automation.

Whoops, I just remembered that you said something about ASTA and
multi-threading, so presumably all this is running on a separate
thread - in which case the session for that thread will have set
TimerInterval to 0 intentionally.

In the short term, rather than altering IBO code, I would suggest
that you explicitly commit the internal transaction in your own
code. You can cycle through all transactions on a connection using
the TransactionCount and Transactions properties.

In the meantime I want to find out why the transaction needs
explicitly stopping anyway.

Geoff Worboys
Telesis Computing