Subject Firebird 2.5 Returning clause problem
Author grenzil
Hi,

I'm using Firebird for several program and everthing works like a charm.
Some days ago I installed FB 2.5 RC1 in order to verify with our software. Unfortunately I encounter this problem:

CREATE TABLE STRING_VALUES
(
S_ID Integer NOT NULL,
S_CHAR Char(255),
S_VARCHAR Varchar(255),
S_NCHAR Char(255),
S_NVARCHAR Varchar(255),
S_BIT Blob sub_type 1,
S_VARBIT Blob sub_type 0,
PRIMARY KEY (S_ID)
);

DELETE FROM STRING_VALUES WHERE S_ID=1
INSERT INTO string_values VALUES (1,'''', '''', '''', '''', NULL, NULL) RETURNING S_ID

We call severl
isc_dsql_describe sqld = 1 sqln = 0
isc_dsql_describe_bind sqld = 0 sqln = 0 Zero input parameters
isc_dsql_execute2 stExecProc sqld = 1 sqln = 1 var type 497
isc_dsql_fetch sqld = 1 sqln = 1

((497, 0, 0, 4, '', $B47EEC, 4, ('S', '_', 'I', 'D', #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0), 13, ('S', 'T', 'R', 'I', 'N', 'G', '_', 'V', 'A', 'L', 'U', 'E', 'S', #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0), 6, ('S', 'Y', 'S', 'D', 'B', 'A', #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0), 4, ('S', '_', 'I', 'D', #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0, #0)))

After calling isc_dsql_fetch we receive this error

Error Code: -504. Unknown cursor

I took a look at the library changes but I haven't noticed any big
changes related to this side of the library

So, my question is.. Has somebody the same error?
How can i solve it?

Best regards