Hi
The default option in sqlapi is CommitRetaining=false.(As written in
the documentation :
http://www.sqlapi.com/ServerSpecific/InterBase.html#Connection_and_com
mand_options
)

I've also set this option hard coded to false just to make sure.
But still, only reconnecting once in a while works arround this
problem.
-gili

--- In firebird-support@yahoogroups.com, "mikcaau" <macomp@s...>
wrote:

> --- In firebird-support@yahoogroups.com, "cosamektoo"

<gbuzaglo@c...>

> wrote:
> >
> > Hi and thanks
> > It seems to me that there is a bug in SQLAPI library.
> > When I dont connect the client through this library,
> > the numbers of next transaction and last snapshot stay close

together.

> > The only workarround that I found is to disconnect and reconnect

the

> > SQLAPI db connection every X minutes.I think that even though I
> > commit every read operation through that connection, it causes
> > the database to keep transactions open.
> > What do you think about this conclusion ?
> > Thanks
> > -gili
> Gili,
> I don't use SqlApi. You need to make sure that you are not
> CommitRetaining because that will keep a reference to the record.
> I assume you have the source so you can trace it back and see what

is

> happening.
> Mick