Subject | Firebird 2.5 Returning clause problem |
---|---|
Author | grenzil |
Post date | 2010-01-04T18:29:56Z |
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
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