Subject Re: What is the proper transaction level
Author colinriley666
--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@...> wrote:


> Those problems can be avoided by not using the read-only option on
> read-committed transactions that look at blobs.
>

To avoid "gap" problems with OIT/OAT etc I've just changed my
application to use read-only read-committed transactions everywhere.
Updates to data are done via read-write transactions. This is achieved
using the FibPlus components, where a query (TpFibDataset) can have a
read transaction AND an update transaction.

I'm also suffering with "blob not found" errors, and many of my
queries retrieve blobs.

So I have to change back to not using read-only?

regards, Colin