Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

UPDATE OR INSERT with RETURNING causes "Invalid Cursor" error [CORE3203] #3577

Closed
firebird-automations opened this issue Oct 28, 2010 · 13 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Rodrigo Coelho (n3rv0u5)

Is related to CORE2903

Attachments:
UpdateOrInsert.rar

When I execute the UPDATE OR INSERT command with RETURNING occurs a "Invalid Cursor" error

Sometimes the command is not execute successfully.

Commits: d15dc50 1ee06e5

====== Test Details ======

Archieve does not contain necessary dll (dbxfb.dll), but even after downloading it launching of `Project1.exe ` produces "unsupported on-disk structure for file C:\TEMP\UPDATEORINSERT-1\UPDATEORINSERT\UPD_OR_INS.FDB; found 11.2, support 11.1". Need backup of that database.

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

What is the *exact* error message returned by the server?

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

description: When I execute the UPDATE OR INSERT command with RETURNING_VALUES occurs a "Invalid Cursor" error

Sometimes the command is not execute successfully.

Sincerely,
Rodrigo.

=>

When I execute the UPDATE OR INSERT command with RETURNING_VALUES occurs a "Invalid Cursor" error

Sometimes the command is not execute successfully.

summary: UPDATE OR INSERT causes Cursor error => UPDATE OR INSERT with RETURNING_VALUES causes "Invalid Cursor" error

@firebird-automations
Copy link
Collaborator Author

Commented by: Rodrigo Coelho (n3rv0u5)

"Invalid Cursor reference
Cursor is not open."

This error is show on Delphi application.

I attached a sample demonstrating it.

Steps to reproduce:

1 - Type an ID and Name;
2 - Click on "It not works";
3 - Click on "It works"

Sincerely,
Rodrigo.

@firebird-automations
Copy link
Collaborator Author

Modified by: Rodrigo Coelho (n3rv0u5)

Attachment: UpdateOrInsert.rar [ 11805 ]

description: When I execute the UPDATE OR INSERT command with RETURNING_VALUES occurs a "Invalid Cursor" error

Sometimes the command is not execute successfully.

=>

When I execute the UPDATE OR INSERT command with RETURNING occurs a "Invalid Cursor" error

Sometimes the command is not execute successfully.

summary: UPDATE OR INSERT with RETURNING_VALUES causes "Invalid Cursor" error => UPDATE OR INSERT with RETURNING causes "Invalid Cursor" error

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => In Progress [ 3 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is related to CORE2903 [ CORE2903 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: In Progress [ 3 ] => Open [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Please try the next snapshot build (to appear in a couple of days) and report back. It should be fixed there.

@firebird-automations
Copy link
Collaborator Author

Commented by: Rodrigo Coelho (n3rv0u5)

OK, the problem was fixed

Thanks,
Rodrigo.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5.1 [ 10333 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: Cannot be tested

Test Details: Archieve does not contain necessary dll (dbxfb.dll), but even after downloading it launching of `Project1.exe ` produces "unsupported on-disk structure for file C:\TEMP\UPDATEORINSERT-1\UPDATEORINSERT\UPD_OR_INS.FDB; found 11.2, support 11.1". Need backup of that database.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants