Subject | RE: [IBO] Unknown Cursor Exception |
---|---|
Author | Jason Wharton |
Post date | 2006-11-07T05:12:21Z |
This sounds like a good obscure problem that if I could get a sample app of
I'd like to smoothen out. It won't be really high priority, as I have other
priority items I'm working on right now, but I would eventually like to have
a closer look.
Jason
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On Behalf
Of Alan McDonald
Sent: Friday, October 27, 2006 6:28 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Unknown Cursor Exception
I've finally found - only took 3 years... why I get that annoying exception
which is really harmless in the scheme of things but which annoys the hell
out me.
For those of you who have also experienced it...here it is and it all makes
common sense.
I use IB_Transaction.Refresh(True) a lot. I like the way the grids stay
untouched, so to speak and the buffer control on IB_Grids was the main
reason I moved to IBO.
When you call the Query.Delete method while sitting on a grid row, then call
Refresh(True), IBO nicely realises that it cannot return the buffer to this
row. You do not get this exception. But when you end up deleting a record in
the buffer which is currently selected in the grid via another component
e.g. a cursor DELETE statement and then call Refresh(True), of course the
grid has not been informed of the relevance of this delete and the buffers
try to locate this record (especially when the Query is set to raKeepRowNum
(which is what I like).
and then bang... the exception.
I can work around this no problems - many ways of doing it know that I know
why it happens.
regards
Alan McDonald
I'd like to smoothen out. It won't be really high priority, as I have other
priority items I'm working on right now, but I would eventually like to have
a closer look.
Jason
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On Behalf
Of Alan McDonald
Sent: Friday, October 27, 2006 6:28 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Unknown Cursor Exception
I've finally found - only took 3 years... why I get that annoying exception
which is really harmless in the scheme of things but which annoys the hell
out me.
For those of you who have also experienced it...here it is and it all makes
common sense.
I use IB_Transaction.Refresh(True) a lot. I like the way the grids stay
untouched, so to speak and the buffer control on IB_Grids was the main
reason I moved to IBO.
When you call the Query.Delete method while sitting on a grid row, then call
Refresh(True), IBO nicely realises that it cannot return the buffer to this
row. You do not get this exception. But when you end up deleting a record in
the buffer which is currently selected in the grid via another component
e.g. a cursor DELETE statement and then call Refresh(True), of course the
grid has not been informed of the relevance of this delete and the buffers
try to locate this record (especially when the Query is set to raKeepRowNum
(which is what I like).
and then bang... the exception.
I can work around this no problems - many ways of doing it know that I know
why it happens.
regards
Alan McDonald