关于SQL模糊查询时的传值问题? 在线等待!谢谢!

Question

 with datamodule5.ADOQuery1  do
        begin
          close;
          sql.clear;
          sql.Add('select * from vipmem where vipname LIKE ''%vna%''');                            Parameters.ParamByName('vna').Value:=Edit5.text;
          
          open;
        end;
谢谢!

Answer 1

with datamodule5.ADOQuery1  do
        begin
          close;
          sql.clear;
          sql.Add('select * from vipmem where vipname LIKE ' + QuotedStr('%' + Edit1.text + '%'));
          open;
        end;

Answer 2

with datamodule5.ADOQuery1  do
        begin
          close;
          sql.clear;
          sql.Add('select * from vipmem where vipname LIKE '+ '%' + #39 + Edit1.text + #39 + '%'));
          open;
        end;

Answer 3

能用传递参数的形式吗?
如题
with datamodule5.ADOQuery1  do
        begin
          close;
          sql.clear;
          sql.Add('select * from vipmem where vipname LIKE '%vna%'');                            Parameters.ParamByName('vna').Value:=Edit5.text;
          
          open;
        end;

Answer 4

with datamodule5.ADOQuery1 do
begin
close;
sql.clear;
sql.Add('select * from vipmem where vipname LIKE :vna);Parameters.ParamByName('vna').Value:='%'+Edit5.text'%';open;
end;查找所有包含EDIT5中内容的记录

Answer 5

sql.Add('select * from vipmem where vipname LIKE '%vna%'');    改成
sql.add('select * from vipmem where vipname like ''vna%''');

Answer 6

谢谢
 qxj(Diamondback)接分.