动态修改sql的困惑。。。。。。。。。。。。。。

[ctrlqrj]

adoquery1.SQL.clear;
adoquery1.SQL.Text:='select dm,pm,gg,jfjg1 from fw where dm="edit1.text"';
adoquery1.Open;

以上代码写出后发现并不能修改sql，请问应如何写才合适

[ctrlqrj]

快帮个忙啦！！！！

[suny_2001]

with adoquery1 do
begin
close;
SQL.clear;
SQL.add('select dm,pm,gg,jfjg1 from fw where dm='''+edit1.text+''');
Open;
end;

[suny_2001]

SQL.add('select dm,pm,gg,jfjg1 from fw where dm='''+edit1.text+'''');
少了个引号

[pingzitt]

adoquery1.SQL.add('select dm,pm,gg,jfjg1 from fw where dm=:dm');
ADOquery1.parameter.parabyname('dm').value:=edit1.text;
ADOquery1.open;

[jyqkr]

adoquery1.SQL.add('select dm,pm,gg,jfjg1 from fw where dm=:dm');
ADOquery1.parameter.parabyname('dm').value:=edit1.text;
ADOquery1.open;

[ctrlqrj]

不好意思，分数是少了点，但非常感谢你们