我用的是:
AdoQery1.Close;
AdoQery1.Clear;
AdoQery1.SQL.Text='Select * from tb_Client Where companyname like '+#39+'%'+edt_company.Text+'%'+#39;
AdoQery1.Open;
但运行时报fro子句语法错,
AdoQery1.Close;
AdoQery1.Clear;
AdoQery1.SQL.Text='Select * from tb_Client Where companyname like '+#39+'%'+edt_company.Text+'%'+#39;
AdoQery1.Open;
但运行时报fro子句语法错,
AdoQery1.Clear;
AdoQery1.SQL.Text='Select * from tb_Client Where companyname like ''%'+edt_company.Text+'%'''
AdoQery1.Open;
AdoQery1.SQL.Text='Select * from tb_Client Where companyname like "%'+edt_company.Text+'%"'