Subject Re: Re: [IBO] Transaction->ReadOnly = true
Author Paul Hope
Hi Helen

> It's not the transaction isolation that causes the OAT to get stuck. It's
> having read-write transactions that don't get committed, or that use
> CommitRetaining. If you have your read-write transactions in AutoCommit
> mode, you are getting CommitRetaining, not hard Commits.
I am a little concerned by this and would like it clarified. Does this mean
that if I just put a TIB_Query on a form with a Select statement, leave the
IB_Transaction as <default> then open the query and leave the form open my
OAT will be stuck?

Does it imply that every read-only operation should use a ReadOnly
transaction and that every updating thing (TIB_Query, TIB_Cursor, TIB_DSQL
etc) should not use AutoCommit?