...
close;
sql.clear;
sql.Add('Select CustomerId,CustomerName where customername like ''% :name %''');<------------
ParamByName('name').Value:=edit1.text ;
prepare;
open;
...
close;
sql.clear;
sql.Add('Select CustomerId,CustomerName where customername like ''% :name %''');<------------
ParamByName('name').Value:=edit1.text ;
prepare;
open;
...
sql.clear;
sql.Add('Select CustomerId,CustomerName where customername like :name ');
ParamByName('name').Value:='%'+edit1.text +'%';
prepare;
open;
sql.clear;
sql.Add('Select CustomerId,CustomerName from TableName
where customername like '+'''% :name %''');-----<注意不用用中文的:
ParamByName('name').Value:=edit1.text ;
prepare;
open;
select * from table where customername like %西安%
也是出错。
你忘了加引号呀 select * from table where customername like '%西安%'
建议:把你的表名(Table)重新命名!!
建议:把你的表名(Table)重新命名!!如:Customer!
sql.clear;
sql.Add('Select CustomerId,CustomerName from table where customername like :name ');
ParamByName('name').Value:='%'+edit1.text +'%';
prepare;
open;