Subject | Re: What is the proper transaction level |
---|---|
Author | colinriley666 |
Post date | 2006-08-17T15:01:20Z |
--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@...> wrote:
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
<aharrison@...> wrote:
> Those problems can be avoided by not using the read-only option onTo avoid "gap" problems with OIT/OAT etc I've just changed my
> read-committed transactions that look at blobs.
>
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