Subject Ivalid cursor reference error with Firebird 2.5.0.26074
Author Svend Meyland Nicolaisen
Hi



I am testing with Firebird 2.5.0.26074 64 bit. I have previously been using
Firebird 2.1.5 64 bit. Suddenly I am getting the following error when
executing the query below. Can anybody help me find out why this is?



Dynamic SQL Error

SQL error code = -504

Invalid cursor reference

Cursor is not open



Query:



INSERT INTO "TblUsers" (

"Blacklisted",

"Email",

"EmploymentId",

"EndDate",

"ExtUserId",

"FirstName",

"Initials",

"MobilePhone",

"Phone",

"PictureDate",

"PinCode",

"StartDate",

"SurName",

"Title")

VALUES (

@Blacklisted,

@Email,

@EmploymentId,

@EndDate,

@ExtUserId,

@FirstName,

@Initials,

@MobilePhone,

@Phone,

NULL,

@PinCode,

@StartDate,

@SurName,

@Title)

RETURNING "ID"



My platform is Windows Vista 64 bit.



Kind regards,

Svend



[Non-text portions of this message have been removed]