我是这样写的,可是行不通啊,还请各位详细说一下: query1.sql.add('select * from custom'); query1.sql.add('where id like %edit1.text%'); query1.open; 谢谢!
query1.sql.add('where id like '''+'%edit1.text%'+''''); 你忘加了引号,上面都是单引号! Select ....where id like '%a%' 必须是这样
var filterStr:string; begin filterStr:='%'+trim(edit1.text)+'%'; query1.clear; query1.sql.add('select * fom custom'); query1.sql.add('where id like :filterStr'); query1.Parameters.ParamByName('t').Value:=t; query1.active:=true; end;
query1.sql.add('select * from custom'); query1.sql.add('where id like ''%'+Trim(Edit1.Text)+'%'')'; query1.open;
Table1.Filter:='ID=9878*';
Table.Filtered:=true;
query1.sql.add('select * from custom');
query1.sql.add('where id like %edit1.text%');
query1.open;
谢谢!
你忘加了引号,上面都是单引号!
Select ....where id like '%a%'
必须是这样
filterStr:string;
begin
filterStr:='%'+trim(edit1.text)+'%';
query1.clear;
query1.sql.add('select * fom custom');
query1.sql.add('where id like :filterStr');
query1.Parameters.ParamByName('t').Value:=t;
query1.active:=true;
end;
query1.sql.add('where id like ''%'+Trim(Edit1.Text)+'%'')';
query1.open;
这句有什么作用,好像我不用都可以的
你忘加了引号,上面都是单引号!
Select ....where id like '%a%'
你试过这个吗?