Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Table update error


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 0
Jim Sawyer

Posts: 214
Registered: 1/3/10
Table update error  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 25, 2017 1:31 PM
I am using the following code:

  patQuery := TFDQuery.Create( AConnection );
  with patQuery do
  begin
    Connection := AConnection;
    SQL.Add( 'Update Patient join client ' );
    SQL.Add( 'on Client.Clino = Patient.Clino ' );
    SQL.Add( 'set Patient.MindSel = true ' );
    SQL.Add( 'where Client.Clino > 10000' );
    ExecSQL;
  end;


I get the following error:

"Can't perform this operation on a closed dataset"

What have I got wrong?

Thanks,
Jim Sawyer
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02