Watch, Follow, &
Connect with Us

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

Welcome, Guest
Guest Settings

Thread: Table update error

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

Permlink Replies: 0 Threads: [ Previous | Next ]
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
    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' );

I get the following error:

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

What have I got wrong?

Jim Sawyer
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02