Question

delphi7三层模糊查询

服务端这么写：select * from Z_chukugenzong where CPname like '%:CPname%'
客户端：
ClientDataSet_mhcx.close;
ClientDataSet_mhcx.fetchparams;
ClientDataSet_mhcx.params.ParamByName('CPname').asstring:=Trim(ComboBox_Cpname.Text);
ClientDataSet_mhcx.open;
，现在知道服务端不对 ，请问怎么改啊？

Answer 1

select * from Z_chukugenzong where CPname like :CPname

。。。。

ClientDataSet_mhcx.params.ParamByName('CPname').asstring:=‘%’ + Trim(ComboBox_Cpname.Text) + ‘%’;