这样就没有问题了
procedure TForm1.Button1Click(Sender: TObject);
var i:integer;
begin
query1.SQL.Clear;
for i:=0 to memo1.Lines.Count-1 do
Begin
query1.SQL.Add(memo1.Lines.Strings[i]);
End;
query1.Active:=true;
end;
procedure TForm1.Button1Click(Sender: TObject);
var i:integer;
begin
query1.SQL.Clear;
for i:=0 to memo1.Lines.Count-1 do
Begin
query1.SQL.Add(memo1.Lines.Strings[i]);
End;
query1.Active:=true;
end;
ClientData.CommandText:=Memo1.Lines.Text;
ClientData.Open;
你的SQL语是不是Select
如是Select 就应用open 或 Active:= true 去执行.
如果是Insert delete ...就用Exectue