There are tools to help you pinpoint if a transaction is left open or not.
Take a look at the TIB_StatusDialog component.

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

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Arno Garrels" <arno.garrels@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, December 02, 2002 12:37 PM
Subject: Re: [IBO] Re: Database file size increases heavily


> I changed the source to Explicit Transaction handling.
> Now Commit is called whenever it might be usefull, but the problem remains
> the same.
>
> No database no cry
>
> Arno Garrels
>
>
> ----- Original Message -----
> From: <lester@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Monday, December 02, 2002 1:50 PM
> Subject: Re: [IBO] Re: Database file size increases heavily
>
>
> > > I'm not a guru on this, so I could tell you lies, but as far as I
> > > remember reading posts in this newsgroup, I'm sure that a
> > > "myTransaction.Commit" will help a lot.
> >
> > Think you have hit it spot on!
> >
> > Only 5Mb in 10 hours - BDE/IB could manage that in 10 mins <g>
> >
> > --
> > Lester Caine
> > -----------------------------
> > L.S.Caine Electronic Services