Subject | Problem with IB_Cursor.First |
---|---|
Author | Carlos H. Cantu |
Post date | 2001-08-13T16:48:35Z |
I just upgraded to IBO 4.2Ea. Now when I call the first method for a
IB_Cursor I'm getting :
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:Dynamic SQL Error
SQL error code = -804
Incorrect values within SQLDA structure
Any idea of what is going on here ? The cursor is prepared OK and the SQL
is :
SELECT (SELECT MIN(COD_USU) FROM RH) AS MINIMO,
(SELECT GEN_ID(GEN_USUARIO,0) FROM RDB$DATABASE) AS MAXIMO
FROM RDB$DATABASE
Doing a trace I found the erro begin cause in the maked line :
procedure TIB_Dataset.SysFirst;
begin
SysBeforeScroll;
if Active then
SysClose;
SysOpen;
if CursorBof and not CursorEof then
SysFetchNext; <=======================
SysAfterScroll;
end;
[]s
Carlos
WarmBoot Informatica - http://www.warmboot.com.br
Interbase-BR - http://www.interbase-br.com
IB_Cursor I'm getting :
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:Dynamic SQL Error
SQL error code = -804
Incorrect values within SQLDA structure
Any idea of what is going on here ? The cursor is prepared OK and the SQL
is :
SELECT (SELECT MIN(COD_USU) FROM RH) AS MINIMO,
(SELECT GEN_ID(GEN_USUARIO,0) FROM RDB$DATABASE) AS MAXIMO
FROM RDB$DATABASE
Doing a trace I found the erro begin cause in the maked line :
procedure TIB_Dataset.SysFirst;
begin
SysBeforeScroll;
if Active then
SysClose;
SysOpen;
if CursorBof and not CursorEof then
SysFetchNext; <=======================
SysAfterScroll;
end;
[]s
Carlos
WarmBoot Informatica - http://www.warmboot.com.br
Interbase-BR - http://www.interbase-br.com