Subject TIB_Cursor - Cursor is not open Exception
Author Luiz
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