用sql语句的%,如select * from 表名 where djh like '%11%'就OK了。
对呀。用SQL语句的like '%11%' 就好了
用database,adoconnection,adoquery,dbgrid;就可以了, with adoquery1 do begin close; sql.clear; sql.add('select * from tab_name wherre nn like ''%''+:a+''%'''); parameters.parameterbyname('a').value:=edit1.text; open; end;
with query do begin close; sql.clear; sql.add('select * from 表名 where djh like ''%'+edit1.text+'%'''); open; end; 完全通过..
with query do begin close; sql.clear; sql.add('select * from 表名 where djh like '+quotedstr('%'+edit1.text+'%'')); open; end;
with adoquery1 do begin close; sql.clear; sql.add('select * from tab_name wherre nn like ''%''+:a+''%'''); parameters.parameterbyname('a').value:=edit1.text; open; end; ------------------------------------------------------- 同意!!!!!!!
要不你暂时把数据集中的数据存放到一个临时表中,然后用adoquery对象从这个临时表中查询呢?查询语句如下: with adoquery1 do begin close; sql.clear; sql.add('select * from #tab_name wherre nn like ''%''+:a+''%'''); parameters.parameterbyname('a').value:=edit1.text; open; end;
var sqlstr; begin InStr:=InputBox('模糊查询','输入查询条件',''); SqlStr:='Select * from [tablename] where djh like ''%'+InStr+'%'''; with Query do begin Close; Sql.Clear; Sql.Add(SqlStr); open; end; end;
filter:='BillNo>='+''''+sBillNo+''''+''''+chr(0)+''''+' and BillNo<='+''''+sBillNo+''''+''''+chr(255)+'''';
比如用adoquery连接,用dbgrid显示. 就这样写: begin if ADOQuery1.Active then with dbgrid1.datasource.dataset do ADOQuery1.close; ADOQuery1.sql.clear; ADOQuery1.sql.add('select * from table where djh like ''津'+trim(edit1.Text)+'%'''); ADOQuery1.open; end; 以上代码在edit1的SetFocus中.
支持zzlazio的簡單用法!這種方法簡單且好用!
filter:='BillNo>='+''''+chr(0)+''''+''''+sBillNo+''''+''''+chr(0)+''''+' and BillNo<='+chr(255)+''''+''''+sBillNo+''''+''''+chr(255)+'''';
模糊查询其实和Delphi没有必然联系,在SQL语句里写就好了
with adoquery1 do
begin
close;
sql.clear;
sql.add('select * from tab_name wherre nn like ''%''+:a+''%''');
parameters.parameterbyname('a').value:=edit1.text;
open;
end;
begin
close;
sql.clear;
sql.add('select * from 表名 where djh like ''%'+edit1.text+'%''');
open;
end;
完全通过..
begin
close;
sql.clear;
sql.add('select * from 表名 where djh like '+quotedstr('%'+edit1.text+'%''));
open;
end;
begin
close;
sql.clear;
sql.add('select * from tab_name wherre nn like ''%''+:a+''%''');
parameters.parameterbyname('a').value:=edit1.text;
open;
end;
-------------------------------------------------------
同意!!!!!!!
with adoquery1 do
begin
close;
sql.clear;
sql.add('select * from #tab_name wherre nn like ''%''+:a+''%''');
parameters.parameterbyname('a').value:=edit1.text;
open;
end;
begin
InStr:=InputBox('模糊查询','输入查询条件','');
SqlStr:='Select * from [tablename] where djh like ''%'+InStr+'%''';
with Query do
begin
Close;
Sql.Clear;
Sql.Add(SqlStr);
open;
end;
end;
就这样写:
begin
if ADOQuery1.Active then
with dbgrid1.datasource.dataset do
ADOQuery1.close;
ADOQuery1.sql.clear;
ADOQuery1.sql.add('select * from table where djh like ''津'+trim(edit1.Text)+'%''');
ADOQuery1.open;
end;
以上代码在edit1的SetFocus中.