ADOQuery1.Close; ADOQuery1.SQL.Clear; ADOQuery1.SQL.Add('select * from table where name like ''%' + No + '%'''); ADOQuery1.Parameters.ParamByName('No').Value := Edit1.Text; ADOQuery1.Open;
看--->标准代码:query.Close; query.SQL.Clear; query.SQL.Add('select * from table where name like :x_like'); query.parambyname('x_like').asstring:='%' + trim(edit1.text) + '%'; query.Open;肯定行!
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('select * from table where name like ''%' + No + '%''');
ADOQuery1.Parameters.ParamByName('No').Value := Edit1.Text;
ADOQuery1.Open;
query.SQL.Clear;
query.SQL.Add('select * from table where name like :x_like');
query.parambyname('x_like').asstring:='%' + trim(edit1.text) + '%';
query.Open;肯定行!