I'm trying the following code
adoquery1.First;
///delete from table all records of those who have scored under 10 at any time
While not AdoQuery1.eof do begin
If adoquery1['score']<10 then name:=adoquery1['name'];
AdoQuery1.Close;
AdoQuery1.SQL.Clear;
AdoQuery1.SQL.Add('DELETE *');
AdoQuery1.SQL.Add('From Table1');
AdoQuery1.SQL.Add('Where name='+QuotedStr(name));
AdoQuery1.ExecSQL;
Now the problem starts
if I use
adoquery1.Next;
I get the error message Cannot perform this operation on a closed dataset.
If I use
adoquery1.open;
adoquery1.Next;
I get the error message
Current provider does not support returning multiple recordsets from a single execution.
Start Free Trial
