commandText:='select * from custom where addr like ''%''+:addr+''%'''
select * from custom where addr like %:addr% 也不行
在SQL.Text中添加的话,要这样写:select * from custom where addr like '%%:addr%%'
你直接将值写进去吧:SQL.Text:=Format(select * from custom where addr like '%%%s%%',[addr]);
我用Adoquery add 為參數 with Adoquery do begin close; sql.clear; sql.add('select * from custom'); sql.add(' where addr like'+''''+'%'+add+'%'+''''); open; end;
也不行
with Adoquery do
begin
close;
sql.clear;
sql.add('select * from custom');
sql.add(' where addr like'+''''+'%'+add+'%'+'''');
open;
end;
addr作为变量就OK了
如果内容是一个字串 adoquery.sql.add('select * from custom where addr like'+quotedstr('%'+(你的字串)+'%'))
select * from custom where addr like :addrpara...........:='%'+str+'%'