Subject | Fetch and isc_req_sync error |
---|---|
Author | maverickthunder |
Post date | 2008-07-21T18:39:53Z |
Hi, I'm new to firebird and make this simple test table with an index
in Nombre and a generator in ID:
CREATE TABLE "Data" (
ID INTEGER NOT NULL,
"Nombre" VARCHAR(60) NOT NULL,
"Fecha_Nacimiento" TIMESTAMP NOT NULL,
"Foto" BLOB SUB_TYPE BINARY SEGMENT SIZE 2048,
/* Keys */
PRIMARY KEY (ID)
);
The table has 8 registers and some of them has Foto with NULL
I build a simple query: SELECT * FROM "Data"; by using prepare,
describe and isc_dsql_execute.
But when I use isc_dsql_fetch (all calls using SQL_DIALECT_V6) I got
the 8 registers and in the ninth call instead of getting an EOF, I got
a duplicate of the last register without errors and in the next call I
got "isc_req_sync" error.
The isc_req_sync error sounds logic but I don't know why I does not get
the EOF signal using FB 2.1.1.17910
Best regards,
Mauro H. Leggieri
in Nombre and a generator in ID:
CREATE TABLE "Data" (
ID INTEGER NOT NULL,
"Nombre" VARCHAR(60) NOT NULL,
"Fecha_Nacimiento" TIMESTAMP NOT NULL,
"Foto" BLOB SUB_TYPE BINARY SEGMENT SIZE 2048,
/* Keys */
PRIMARY KEY (ID)
);
The table has 8 registers and some of them has Foto with NULL
I build a simple query: SELECT * FROM "Data"; by using prepare,
describe and isc_dsql_execute.
But when I use isc_dsql_fetch (all calls using SQL_DIALECT_V6) I got
the 8 registers and in the ninth call instead of getting an EOF, I got
a duplicate of the last register without errors and in the next call I
got "isc_req_sync" error.
The isc_req_sync error sounds logic but I don't know why I does not get
the EOF signal using FB 2.1.1.17910
Best regards,
Mauro H. Leggieri