Subject | RE: [IBO] Re: RefreshRows on TIBOTable fails |
---|---|
Author | IBO Support List |
Post date | 2013-09-04T15:11:12Z |
If you have it happening in your main application in a reliable way, perhaps
I could do a TeamViewer session and have a look at it. What would be really
great is if you could get a callstack on the exception. Often times with
just that I can know what I need to in order to address the problem.
Also, I might be able to work with you more closely in the creation of a
sample app. We can set all of the timings to a really short duration to help
accellerate the problem showing up.
Thanks,
Jason
www.ibobjects.com
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Sammy Vergeylen
Sent: Wednesday, September 4, 2013 12:46 AM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Re: RefreshRows on TIBOTable fails
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:
Behalf
__________________________________________________________
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]
------------------------------------
___________________________________________________________________________
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 !
http://tracker.ibobjects.com - your portal to submit and monitor bug reports
http://community.ibobjects.com - your portal to purchase and upgradeYahoo!
Groups Links
I could do a TeamViewer session and have a look at it. What would be really
great is if you could get a callstack on the exception. Often times with
just that I can know what I need to in order to address the problem.
Also, I might be able to work with you more closely in the creation of a
sample app. We can set all of the timings to a really short duration to help
accellerate the problem showing up.
Thanks,
Jason
www.ibobjects.com
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Sammy Vergeylen
Sent: Wednesday, September 4, 2013 12:46 AM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Re: RefreshRows on TIBOTable fails
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:
>the
> Can you reliably reproduce the problem?
> If so, I would very much appreciate you providing me steps to reproduce
> problem. Ideally, I would love to have you put together a little sampleapp.
>[mailto:IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.com>] On
> Thanks,
> Jason
>
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.com>
Behalf
> Of sammy_flexSupport List" <supportlist@>
> 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
> wrote:[mailto:IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.com>] On
> >
> > 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>
> > Behalf Of sammy_flex"IBO Support List" <supportlist@>
> > 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>,
> > wrote:[mailto:IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.com>]
> > >
> > > 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>
> > > 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 orInterBase
> without the need for BDE, ODBC or any other layer.__________________________________________________________
>
> http://www.ibobjects.com - your IBO community resource for Tech Infopapers,
> 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]
------------------------------------
___________________________________________________________________________
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 !
http://tracker.ibobjects.com - your portal to submit and monitor bug reports
http://community.ibobjects.com - your portal to purchase and upgradeYahoo!
Groups Links