Paul,

it seems that you are suffering from the same delusions we were. Helen
set us striaght in the firebird forum. Here it is in plain English :-)

1. Autocommit true does soft commits, which does not release the
transaction. So I suggest dont use it unless the transaction has been
setup as readonly and you use it only for selects.

2. Selects require a commit too (unless performed with a readonly
transactrion).



Paul Hope wrote:

> Hi
>
> I suspect I have OAT problems and would appreciate some help as to
> where to look.