Welcome, Guest
Username: Password: Remember me
Discussions for CodeTyphon Studio Installation and Setup.
  • Page:
  • 1

TOPIC:

Transaction.Commit -Attempt to reclose a closed cursor. 3 years 2 months ago #15514

  • Rafał
  • Rafał's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 22
  • Thank you received: 0
In CT7.3, Windows 10, Firebird 3.0

I have problem with TSQLTransaction.

I have TSQLQuery with "insert into tbluser (name, surname) values (:p1, :p2) returning id"  then
SQLQuery.Open.
id:=SQLQuery.FieldByName('id').AsString;
SQLTransaction.Commit - here i receive error "-Attempt to reclose a closed cursor"

in CT7.2 it was works fine. 

if I replace SQLTransaction.CommitRetaining - it's working. 

 

Please Log in or Create an account to join the conversation.

Last edit: by Rafał.

Transaction.Commit -Attempt to reclose a closed cursor. 3 years 2 months ago #15517

  • Matis A.
  • Matis A.'s Avatar
  • Away
  • Moderator
  • Moderator
  • Posts: 1060
  • Thank you received: 149
Sir we follow FreePascal SVN changes in code
PilotLogic Core Programmer

Please Log in or Create an account to join the conversation.

  • Page:
  • 1