On 1/10/2011 10:52 PM, munster77054 wrote:

>
> The minimum I had to put in, on the aux table screen was:
>
> DataModule2->IBTransaction1->CommitRetaining();
>
> If I used
>
> DataModule2->IBTransaction1->Commit();
>
> Every thing would close.
>

Right. But as Helen said there's another kick coming. Commit
retaining doesn't release the "oldest active" transaction id,
so it continues to inhibit garbage collection. I realize that
a commit closes all cursors, so you probably don't want to do
that every time, but you should define the scope of transactions
so you can do real commits regularly.


Cheers,

Ann