delphi中关于一给模糊查询【很郁闷。。。】

[QQ12236822]

 commandtext:='select id from ST_LLD where ZHTH='''+spub_zhth+''' and  ND='''+spub_nd+''' AND DH='''+dhedit.text+'''';

dh后面写 like ％　　老是弄错　

大家帮帮忙

谢谢

[hushu02]

commandtext:='select id from ST_LLD where ZHTH='''+spub_zhth+''' and  ND='''+spub_nd+''' AND DH like ''%'+dhedit.text+''''

[mandarin]

引号用QuotedStr，看着舒服

[火龙岛主]

commandtext:='select id from ST_LLD where ZHTH='+QuotedStr(spub_zhth)+' and  ND='+QuotedStr(spub_nd)+' AND DH like '+QuotedStr('%'+dhedit.text);

[gzmhero]

commandtext:='select id from ST_LLD where ZHTH='''+spub_zhth+''' and ND='''+spub_nd+''' AND DH like ''%'+dhedit.text+'''';

[bdmh]

commandtext:='select id from ST_LLD where ZHTH='+QuotedStr(spub_zhth)+' and ND='+QuotedStr(spub_nd)+' AND DH='+QuotedStr('%'+dhedit.text);

[阿三]

用绑定参数比较好,比拼SQL简单
sql.text := 'select id from st_lld where zhth=:zhth and nd=:spub_nd and dh like :db';
parameters.parambyname('zhth').value := '';
....

[DMU_WD]

sql语句就是双引号和单引号的游戏 认真点就ok了

[kernel001]

[Quote=引用 6 楼 zxf_feng 的回复:]
用绑定参数比较好,比拼SQL简单
sql.text := 'select id from st_lld where zhth=:zhth and nd=:spub_nd and dh like :db';
parameters.parambyname('zhth').value := '';
....
[/Quote]

支持

[ydysnIV]

commandtext:='select id from ST_LLD where ZHTH='''+spub_zhth+''' and ND='''+spub_nd+''' AND DH='+#39 + '%' +dhedit.text+'%'+#39;