Hi Jason,

We did not manage to reproduce the issue in a sample application with sample database.

We noticed that some errors are gone by using the autofetchall (for smaller tables) and using horizontalAlignment with a descending index on the primary key (for the big tables).
I suppose the access violation is the consequence of a timeout somehow.

So for now our problems are solved, but we're still testing the complete application.

Thanks for the support,


Sammy Vergeylen

M: sv@...
S: www.flexsoft.be
flexsoft

dental

legal

ERP

system integration


If for any reason you no longer want to receive mails from FlexSoft, please send us an email to unsubscribe. Privacy is important to us, therefore we will not sell, rent, or give your name or address to any third party. If you have any questions or comments, feel free to contact us: info@...
The information in this email is intended only for the addressee(s) named above. Access to this email by anyone else is unauthorised. If you are not the intended recipient of this message any disclosure, copying, distribution or any action taken in reliance on it is prohibited and may be unlawful.
Van: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] Namens IBO Support List
Verzonden: maandag 2 september 2013 17:17
Aan: IBObjects@yahoogroups.com
Onderwerp: RE: [IBO] Re: RefreshRows on TIBOTable fails



How are you coming along on producing a sample app for this issue?

Thanks,
Jason

-----Original Message-----
From: IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.com> [mailto:IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.com>] On Behalf
Of sammy_flex
Sent: Monday, August 26, 2013 2:21 AM
To: IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.com>
Subject: [IBO] Re: RefreshRows on TIBOTable fails

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<mailto:IBObjects%40yahoogroups.com>, "IBO Support List" <supportlist@...<mailto: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%40yahoogroups.com> [mailto:IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.com>] On

Behalf

> Of sammy_flex
> Sent: Thursday, August 22, 2013 9:11 AM
> To: IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.com>
> Subject: [IBO] Re: RefreshRows on TIBOTable fails
>
> Thanks for the reply, but unidirectional is still on 'false'.
>
>
> --- In IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.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%40yahoogroups.com> [mailto:IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.com>] On
> > Behalf Of sammy_flex
> > Sent: Wednesday, August 21, 2013 3:50 AM
> > To: IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.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<mailto:IBObjects%40yahoogroups.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%40yahoogroups.com> [mailto:IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.com>]
> > > On Behalf Of sammy_flex
> > > Sent: Tuesday, August 20, 2013 3:36 AM
> > > To: IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.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
>

------------------------------------

__________________________________________________________
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

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]