> the hell of it I add a exit to the get schema call deep within IBO
> to stop that SELECT happening and now my app increments the
> transaction IDs and the database growth is stopped!

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.

This should solve your immediate problem - as the timer will set off
automatic checking of transactions and the internal transaction will
get stopped after 2 - 5 minutes.


Mind you I am a little puzzled by the fact that the internal
transaction is staying started anyway (and I can see that happen here
when TimerInterval is set to zero). It is set to AutoCommit and
statements are active - so it seems to me that it should not need to
be stopped by the automation anyway. I will investigate this further.

--
Geoff Worboys
Telesis Computing