Subject RES: [IBO] TIB_Cursor - Cursor is not open Exception
Author Luiz

I am now renew my subscription to source code.
But, I am getting randomic AV with tib_grid.
I have several modal forms. I open a form with tib_grid and all is ok.
I open another and also is ok. Then, I continue opening others forms and the
error occurs.
If you can help me with this I will appreciate.
I can´t get a call stack when the AV happens.




De: []
Enviada em: sábado, 18 de outubro de 2014 18:03
Assunto: RE: [IBO] TIB_Cursor - Cursor is not open Exception


I consider the behavior in IBO 4.x to be incorrect.
The First method strictly implies that you want to fetch records from a
It should raise an exception if there isn't any dataset.

If you have a large application that depends upon this old behavior, perhaps
you can consider making your own sub-class and override it to have the
proper behaviour you are expecting. Let me know if you need some help to
accomplish this.

Kind regards,
Jason Wharton

-----Original Message-----
From: []
Sent: Saturday, October 18, 2014 12:32 PM
Subject: [IBO] TIB_Cursor - Cursor is not open Exception

Hi Jason,

In IBO 4.X, I was using the next code with TIB_CURSOR to delete a record
from a table and it was working well, but with IBO 5.5.3 EVALUATION version
I have an exception: "Cursor is not open".

If I change "First" to:
Execute; Or
Then, all works well.

I know is better I use tib_dsql to do it, but
I´d like to know if this is normal or a bug.

Here is a snippet of my code:
with cr_config,cr_config.sql do begin
if active then close;
add('delete from UsuLogTime A where A.nh_login='+quotedstr(ll)+' and
add('and A.nh_isnh=1');
first; --> EXCEPTION "Cursor is not open", if change to Execute or
"Prepare;Open" all is ok


Posted by: "Luiz" <cprmlao@...>

IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
__________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more ! - your portal to submit and monitor bug reports - your portal to purchase and upgrade

Yahoo Groups Links