可以直接写成
dm.dw.sql.clear;
dm.dw.sql.add('select * from dw where dw_id='+edit1.Text);
dm.dw.open;
dm.dw.sql.clear;
dm.dw.sql.add('select * from dw where dw_id='+edit1.Text);
dm.dw.open;
调试欢乐多
dm.dw.sq.add('select * from dw where dw_id='+#39+edit1.text+#39);
dm.dw.open;
var
sq:string;
begin
......
sq:='%'+trim(edit1.text)+'%';
......
with dm.dw do
try
if active then close;
sql.clear;
sql.add('select * from dw where dw_id='''+sq+'''');
open;
finally
close;
end;
....
end;