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]

Reply via email to