Nope, no relation at all (except their in the same database).

We're currently investigating if the conversion to subtypes has anything to do with it.

--- In IBObjects@yahoogroups.com, Svein Erling Tysvær <svein.erling.tysvaer@...> wrote:
>
> >> We ported our project from IBO 4.8 to 4.9.14 Build 54.
> >> (Using D7 and Firebird 2.5)
> >>
> >> We converted our BLOB-fields to BLOB SUB_TYPE TEXT or BINAIRY (for
> >> images).
> >>
> >> Since this change some calls to TIBOTable.RefreshRows or .Locate
> >> keep on running.
> >>
> >> Are there some setttings that need to be changed?
> >> The app freezes untill we kill it.
> >
> >I'm working on the sample app.
> >
> >Brief update:
> >We've found out that removing pessimistic lock from another query
> >(not using the same tables or fields), resolves the problem.
> >
> >however we do need this mechanism for this specific query.
> >
> >I'll send the example as soon as it's ready.
>
> Is there any foreign key in either any of the tables with the pessimistic lock query or the "refresh-hanging" query that refers to a record in the other query?
>
> Set
>