> So, in my case , it would probably make sense to set this to true??

Not necessarily. In this mode every logical unit of work has to be
accomplished in a single call to the server. If whatever your stored
procedure does in one call defines a single unit of work than this is
possible. However, if you needed to have operations in a stored procedure as
well as some other actions all wrapped together in a single unit of work
then you need to control transactions from the client and turn server auto
commit to false.

> My sweepinterval (On my connection instance) is set to zero. Zero is the
> default when you drop a component onto a form.
> Is that what you mean? Is zero the default meaning 20,000?

Just ignore this. It really doesn't belong there and I regret putting so
much of that on the connection level. Get a live connection and it won't say
zero unless you made it zero in your database.

By default InterBase gives you 20,000 as your sweep interval.

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