Hello Ivan,
I do not use commitretaining. My application creates a query-object,
creates and starts a transaction, executes the query, commit the
transaction, destroys the transaction-object and destroys the
query-object every time. So normally the Handles should be freed.

Michel

--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@...> wrote:

> Perhaps the problem is not the update itself ?
> Is it possible that you allocate statement handle for each execution
> but do not release it ?
> Perhaps some trigger is involved ?
> Transaction ids indicate that you do not use Commit Retaining, do you ?
>
> Ivan
> http://www.volny.cz/iprenosil/interbase/
>