Subject | TIB_Cursor - Cursor is not open Exception |
---|---|
Author | Luiz |
Post date | 2014-10-18T19:32:22Z |
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
Prepare;
Open;
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:
cr_config:TIB_Cursor;
with cr_config,cr_config.sql do begin
if active then close;
Clear;
add('delete from UsuLogTime A where A.nh_login='+quotedstr(ll)+' and
A.nh_senha='+quotedstr(ss));
add('and A.nh_isnh=1');
first; --> EXCEPTION "Cursor is not open", if change to Execute or
"Prepare;Open" all is ok
unprepare;
close;
end;
Regards,
Luiz
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
Prepare;
Open;
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:
cr_config:TIB_Cursor;
with cr_config,cr_config.sql do begin
if active then close;
Clear;
add('delete from UsuLogTime A where A.nh_login='+quotedstr(ll)+' and
A.nh_senha='+quotedstr(ss));
add('and A.nh_isnh=1');
first; --> EXCEPTION "Cursor is not open", if change to Execute or
"Prepare;Open" all is ok
unprepare;
close;
end;
Regards,
Luiz