R
ruoxi_shuai
Unregistered / Unconfirmed
GUEST, unregistred user!
我想进行模糊查询，程序下该怎么改？
with ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('Select NAME');
SQL.Add('From GZSJK');
SQL.Add('Where BM like );
SQL.Add(':a%');//这里老报错！
Parameters.ParamByName('a').Value := Trim(edit1.Text);
Open;
end;
with ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('Select NAME');
SQL.Add('From GZSJK');
SQL.Add('Where BM like );
SQL.Add(':a%');//这里老报错！
Parameters.ParamByName('a').Value := Trim(edit1.Text);
Open;
end;