Error “Attempt to reclose a closed cursor” executing a query using FireDac
I have a problem with a connection to a database in Firebird 2.0
I'm using Delphi Berlin and the connection is made using FireDac.
In fact the connection test with the FDConnection1 I do it correctly and if I do a FDConnection1.ExecSQL (v_SQL, ) (where v_SQL I have a delete or an insert, it does it correctly.
The problem appears when I put a fdQuery1 and if I double click on it and on the tab I put a simple query:
select * from tipo_cliente
then clicking on the EXECUTE button gives me the following error (and I can not find any of it on the internet):
[FireDac][Phys][FB]Dynamic SQL Error
SQL error code = -501
Attempt to reclose a closed cursor
Of course this query if I take it to some Firebird manager, like IBmanager, works correctly
delphi firebird firedac
edited Jan 21 at 13:08
Mark Rotteveel
60.4k1477121
asked Jan 20 at 12:17
Jerónimo SánchezJerónimo Sánchez
1
add a comment |
I have a problem with a connection to a database in Firebird 2.0
I'm using Delphi Berlin and the connection is made using FireDac.
In fact the connection test with the FDConnection1 I do it correctly and if I do a FDConnection1.ExecSQL (v_SQL, ) (where v_SQL I have a delete or an insert, it does it correctly.
The problem appears when I put a fdQuery1 and if I double click on it and on the tab I put a simple query:
select * from tipo_cliente
then clicking on the EXECUTE button gives me the following error (and I can not find any of it on the internet):
[FireDac][Phys][FB]Dynamic SQL Error
SQL error code = -501
Attempt to reclose a closed cursor
Of course this query if I take it to some Firebird manager, like IBmanager, works correctly
delphi firebird firedac
edited Jan 21 at 13:08
Mark Rotteveel
60.4k1477121
asked Jan 20 at 12:17
Jerónimo SánchezJerónimo Sánchez
1
it sounds like a FireDac bug if this happens in design time
– Marcodor
Jan 20 at 20:19
Strange, did a test in Delphi Berlin 10.1 (build 9432) and but with FB3.0.4, all went okay.
– Marcodor
Jan 20 at 20:41
tipo_clientemight be some complex thing like VIEW, Stored Procedures, Computed Columns or a combination of those. Maybe they have some complex logic inside to run this visibly simple query
– Arioch 'The
Jan 21 at 11:24
add a comment |
I have a problem with a connection to a database in Firebird 2.0
I'm using Delphi Berlin and the connection is made using FireDac.
In fact the connection test with the FDConnection1 I do it correctly and if I do a FDConnection1.ExecSQL (v_SQL, ) (where v_SQL I have a delete or an insert, it does it correctly.
The problem appears when I put a fdQuery1 and if I double click on it and on the tab I put a simple query:
select * from tipo_cliente
then clicking on the EXECUTE button gives me the following error (and I can not find any of it on the internet):
[FireDac][Phys][FB]Dynamic SQL Error
SQL error code = -501
Attempt to reclose a closed cursor
Of course this query if I take it to some Firebird manager, like IBmanager, works correctly
delphi firebird firedac
edited Jan 21 at 13:08
Mark Rotteveel
60.4k1477121
asked Jan 20 at 12:17
Jerónimo SánchezJerónimo Sánchez
1
I have a problem with a connection to a database in Firebird 2.0
I'm using Delphi Berlin and the connection is made using FireDac.
In fact the connection test with the FDConnection1 I do it correctly and if I do a FDConnection1.ExecSQL (v_SQL, ) (where v_SQL I have a delete or an insert, it does it correctly.
The problem appears when I put a fdQuery1 and if I double click on it and on the tab I put a simple query:
select * from tipo_cliente
then clicking on the EXECUTE button gives me the following error (and I can not find any of it on the internet):
[FireDac][Phys][FB]Dynamic SQL Error
SQL error code = -501
Attempt to reclose a closed cursor
Of course this query if I take it to some Firebird manager, like IBmanager, works correctly
delphi firebird firedac
delphi firebird firedac
edited Jan 21 at 13:08
Mark Rotteveel
60.4k1477121
asked Jan 20 at 12:17
Jerónimo SánchezJerónimo Sánchez
1
edited Jan 21 at 13:08
Mark Rotteveel
60.4k1477121
asked Jan 20 at 12:17
Jerónimo SánchezJerónimo Sánchez
1
edited Jan 21 at 13:08
Mark Rotteveel
60.4k1477121
edited Jan 21 at 13:08
Mark Rotteveel
60.4k1477121
edited Jan 21 at 13:08
Mark Rotteveel
60.4k1477121
60.4k1477121
asked Jan 20 at 12:17
Jerónimo SánchezJerónimo Sánchez
1
asked Jan 20 at 12:17
Jerónimo SánchezJerónimo Sánchez
1
asked Jan 20 at 12:17
Jerónimo SánchezJerónimo Sánchez
1
1
it sounds like a FireDac bug if this happens in design time
– Marcodor
Jan 20 at 20:19
Strange, did a test in Delphi Berlin 10.1 (build 9432) and but with FB3.0.4, all went okay.
– Marcodor
Jan 20 at 20:41
tipo_clientemight be some complex thing like VIEW, Stored Procedures, Computed Columns or a combination of those. Maybe they have some complex logic inside to run this visibly simple query
– Arioch 'The
Jan 21 at 11:24
add a comment |
it sounds like a FireDac bug if this happens in design time
– Marcodor
Jan 20 at 20:19
Strange, did a test in Delphi Berlin 10.1 (build 9432) and but with FB3.0.4, all went okay.
– Marcodor
Jan 20 at 20:41
tipo_clientemight be some complex thing like VIEW, Stored Procedures, Computed Columns or a combination of those. Maybe they have some complex logic inside to run this visibly simple query
– Arioch 'The
Jan 21 at 11:24
it sounds like a FireDac bug if this happens in design time
– Marcodor
Jan 20 at 20:19
it sounds like a FireDac bug if this happens in design time
– Marcodor
Jan 20 at 20:19
Strange, did a test in Delphi Berlin 10.1 (build 9432) and but with FB3.0.4, all went okay.
– Marcodor
Jan 20 at 20:41
Strange, did a test in Delphi Berlin 10.1 (build 9432) and but with FB3.0.4, all went okay.
– Marcodor
Jan 20 at 20:41
tipo_cliente might be some complex thing like VIEW, Stored Procedures, Computed Columns or a combination of those. Maybe they have some complex logic inside to run this visibly simple query– Arioch 'The
Jan 21 at 11:24
tipo_cliente might be some complex thing like VIEW, Stored Procedures, Computed Columns or a combination of those. Maybe they have some complex logic inside to run this visibly simple query– Arioch 'The
Jan 21 at 11:24
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54276339%2ferror-attempt-to-reclose-a-closed-cursor-executing-a-query-using-firedac%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54276339%2ferror-attempt-to-reclose-a-closed-cursor-executing-a-query-using-firedac%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
it sounds like a FireDac bug if this happens in design time
– Marcodor
Jan 20 at 20:19
Strange, did a test in Delphi Berlin 10.1 (build 9432) and but with FB3.0.4, all went okay.
– Marcodor
Jan 20 at 20:41
tipo_clientemight be some complex thing like VIEW, Stored Procedures, Computed Columns or a combination of those. Maybe they have some complex logic inside to run this visibly simple query– Arioch 'The
Jan 21 at 11:24