Thanks, I just found the problem... I forgot to revert GDS32.DLL to IB 6
version (I have both instaled).

[]s

Carlos
WarmBoot Informatica - http://www.warmboot.com.br
Interbase-BR - http://www.interbase-br.com

BM> Two things struck me about this :

BM> a) shouldn't it be :

BM> SELECT (SELECT MIN(COD_USU) FROM RH) AS MINIMO,
BM> GEN_ID(GEN_USUARIO,0) AS MAXIMO
BM> FROM RDB$DATABASE

BM> b) This statement should only return 1 row. Thus the use of the IB_DSQL
BM> component would be indicated, the cursor is probably having problems because
BM> it's returning one row.


BM> HTH


BM> Bill Morrison


BM> -----Original Message-----
BM> From: Carlos H. Cantu [mailto:ibo@...]
BM> Sent: Monday, August 13, 2001 9:49 AM
BM> To: IBObjects@yahoogroups.com
BM> Subject: [IBO] Problem with IB_Cursor.First


BM> I just upgraded to IBO 4.2Ea. Now when I call the first method for a
BM> IB_Cursor I'm getting :

BM> ISC ERROR CODE:335544569

BM> ISC ERROR MESSAGE:Dynamic SQL Error
BM> SQL error code = -804
BM> Incorrect values within SQLDA structure

BM> Any idea of what is going on here ? The cursor is prepared OK and the SQL
BM> is :

BM> SELECT (SELECT MIN(COD_USU) FROM RH) AS MINIMO,
BM> (SELECT GEN_ID(GEN_USUARIO,0) FROM RDB$DATABASE) AS MAXIMO
BM> FROM RDB$DATABASE

BM> Doing a trace I found the erro begin cause in the maked line :

BM> procedure TIB_Dataset.SysFirst;
BM> begin
BM> SysBeforeScroll;
BM> if Active then
BM> SysClose;
BM> SysOpen;
BM> if CursorBof and not CursorEof then
BM> SysFetchNext; <=======================
BM> SysAfterScroll;
BM> end;


BM> []s

BM> Carlos
BM> WarmBoot Informatica - http://www.warmboot.com.br
BM> Interbase-BR - http://www.interbase-br.com




BM> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




BM> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/