再改一下:
procedure TForm1.Button1Click(Sender: TObject);
var
s: string;
begin
with ADOQuery1 do//(这是用ADO连接的)
begin
Close;
SQL.Text := 'select sign from myold';
Open;
if ADOQuery1.Fields[0].AsString<>'' then s := ADOQuery1.Fields[0].AsString<>'';
Close;
SQL.Text := 'update myold set sign=''''';
ExecSQL;
end;
end;
procedure TForm1.Button1Click(Sender: TObject);
var
s: string;
begin
with ADOQuery1 do//(这是用ADO连接的)
begin
Close;
SQL.Text := 'select sign from myold';
Open;
if ADOQuery1.Fields[0].AsString<>'' then s := ADOQuery1.Fields[0].AsString<>'';
Close;
SQL.Text := 'update myold'set sign=''''';
ExecSQL;
end;
end;