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.

--- In IBObjects@yahoogroups.com, "IBO Support List" <supportlist@...> wrote:
>
> Can you reliably reproduce the problem?
> If so, I would very much appreciate you providing me steps to reproduce the
> problem. Ideally, I would love to have you put together a little sample app.
>
> Thanks,
> Jason
>
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
> Of sammy_flex
> Sent: Thursday, August 22, 2013 9:11 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Re: RefreshRows on TIBOTable fails
>
> Thanks for the reply, but unidirectional is still on 'false'.
>
>
> --- In IBObjects@yahoogroups.com, "IBO Support List" <supportlist@>
> wrote:
> >
> > Are you by chance setting Unidirectional to true?
> > There was a condition where this could cause a freeze.
> >
> > Jason
> >
> >
> > -----Original Message-----
> > From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On
> > Behalf Of sammy_flex
> > Sent: Wednesday, August 21, 2013 3:50 AM
> > To: IBObjects@yahoogroups.com
> > Subject: Re: [IBO] RefreshRows on TIBOTable fails
> >
> > That's right, the app freezes untill we kill it.
> >
> > I would like to add following details:
> > When flagging on 'AutoFetchAll' the app doesn't freeze anymore but an
> > access violation is thrown.
> > The table has only 3 fields: ID (unique integer), CODE (varchar 24),
> > SETTING (BLOB SUB_TYPE TEXT)
> >
> > Could it have anything to do with the bug you described in Version
> > 5.0.2 [BUILD 45] "I added a check when working with Blob columns and
> > TDataset so that if you are using them in write mode it will check for
> > an edit state and raise a proper exception instead of crashing on an
> access violation."
> >
> > Is this fixed in 4.X as well? We can't just yet use IBO 5.x because
> > this requires some code changes.
> >
> > --- In IBObjects@yahoogroups.com, "IBO Support List" <supportlist@>
> > wrote:
> > >
> > > Do you mean that the app freezes up and you have to end task?
> > >
> > > If possible, can you please provide a little sample app that shows
> > > this problem?
> > >
> > > Also, its possible that this issue could already be resolved in the
> > > more recent version of IBO. If you would like to try and upgrade to
> > > the latest I would be interested in knowing how it works for you.
> > >
> > > Jason
> > >
> > > -----Original Message-----
> > > From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
> > > On Behalf Of sammy_flex
> > > Sent: Tuesday, August 20, 2013 3:36 AM
> > > To: IBObjects@yahoogroups.com
> > > Subject: [IBO] RefreshRows on TIBOTable fails
> > >
> > > 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?
> > >
> > > Many thanks in advance!
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > ____________________________________________________________________
> > > __ _____ IB Objects - direct, complete, custom connectivity to
> > > Firebird or InterBase
> > > without the need for BDE, ODBC or any other layer.
> > > ____________________________________________________________________
> > > __ _____ http://www.ibobjects.com - your IBO community resource for
> > > Tech Info papers, keyword-searchable FAQ, community code
> > > contributions and more !
> > > Yahoo! Groups Links
> > >
> >
> >
> >
> > ------------------------------------
> >
> > ______________________________________________________________________
> > _____ IB Objects - direct, complete, custom connectivity to Firebird
> > or InterBase
> > without the need for BDE, ODBC or any other layer.
> > ______________________________________________________________________
> > _____ http://www.ibobjects.com - your IBO community resource for Tech
> > Info papers, keyword-searchable FAQ, community code contributions and
> > more !
> > Yahoo! Groups Links
> >
>
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>