Delphi SQL - CommandText does not return a result set

Question

I want to delete rows from a grid when I click on a button. How can I do that?

procedure TFormAna.ptal1Click(Sender: TObject);
begin
  QSilMaster.Close;
  QSilDetay.Close;
  QSilMaster.SQL.Text:='delete from IsTakipMaster where id=:pMasterid';
  QSilDetay.SQL.Text:='delete from IsTakipDetay where Masterid=:pid';
  QSilMaster.ExecSQL;
  QSilDetay.ExecSQL;
  QSilMaster.Open;
  QSilDetay.Open;
  //dm.QGenel.Parameters.ParamValues['pid']:=QSilMasterid.Value;
  //dm.QGenel.Parameters.ParamValues['pMasterid']:=QSilDetayMasterid.Value;
  QSilMasterid.Value:=QSilDetayMasterid.Value;
end;

I get this error message:

CommandText does not return a result set

Why do I get this error, and how can I fix it?

DELETE does not return a result set, because it does a DELETE. What result set would you expect? The DELETEd rows? They can't be returned - they've been deleted. DELETE, INSERT and UPDATE will tell you how many rows were changed with the RowsAffected property. SELECT returns a result set. You're getting the error on the calls to Open, which are only used for SELECT. Use ExecSQL for INSERT, UPDATE and DELETE. — Ken White
– Ken White, Commented Mar 5, 2021 at 13:52

fpiette · Accepted Answer · 2021-03-05 13:49:09Z

1

It depends on the component you use for QSilMaster and QSilDetay. But usually you call either ExecSQL or Open but not both. Use ExecSQL for a request which doesn't return any result set (such as your DELETE) and Open for a request returning a result set (Such as a SELECT).

answered Mar 5, 2021 at 13:49

fpiette

12.5k1 gold badge34 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

fpiette Over a year ago

@berk Cinaz Sorry to bother you more, but you still have not accepted my answer. It is the "tick mark" that you have to use.

Collectives™ on Stack Overflow

Delphi SQL - CommandText does not return a result set

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related