用下面的like语句查询数据库,只能查出第一个like的数据,以后的like都起不到查询效果,但也不报错。 with qryTjJhmx do
begin
Close;
SQL.Clear;
SQL.Text:='select * from Spjinhuo where czdate between :a and :b and (gys_name like :spname) or (jhdh=:spname) or (sp_Name like :spname) or (SP_NameJp like :spname) order by id desc';
Parameters.ParamByName('spname').Value:='%'+Edit3.Text+'%';
Parameters.ParamByName('a').Value:=Formatdatetime('yyyy-mm-dd',DateTimePicker5.Date);
Parameters.ParamByName('b').Value:=Formatdatetime('yyyy-mm-dd',DateTimePicker6.Date+1);
Open;
end;
begin
Close;
SQL.Clear;
SQL.Text:='select * from Spjinhuo where czdate between :a and :b and (gys_name like :spname) or (jhdh=:spname) or (sp_Name like :spname) or (SP_NameJp like :spname) order by id desc';
Parameters.ParamByName('spname').Value:='%'+Edit3.Text+'%';
Parameters.ParamByName('a').Value:=Formatdatetime('yyyy-mm-dd',DateTimePicker5.Date);
Parameters.ParamByName('b').Value:=Formatdatetime('yyyy-mm-dd',DateTimePicker6.Date+1);
Open;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货