很简单的啊 adoquery1.sql.add('select * from xm='+''''+edit1.text+'''');
aa:=edit1.text; adoquery1.sql.add('select * from tablename where www=:aa'); adoquery1.params.parambyname('aa'):=edit1.text;ok le!
with Qtemp do begin close; sql.clear; sql.add('SELECT * FROM table '); sql.add('WHERE Qfield= :Qpara'); Parameters.ParaByName('Qpara').Value := Edit1.Text; open; end;
with adoquery1 do begin close; sql.clear; sql.add('SELECT * FROM table '); sql.add('WHERE Qfield= :Qpara'); Parameters.ParaByName('Qpara').Value := Edit1.Text; open; end;
adoquery1.sql.add('select * from xm='+''''+edit1.text+'''');
adoquery1.sql.add('select * from tablename where www=:aa');
adoquery1.params.parambyname('aa'):=edit1.text;ok le!
begin
close;
sql.clear;
sql.add('SELECT * FROM table ');
sql.add('WHERE Qfield= :Qpara');
Parameters.ParaByName('Qpara').Value := Edit1.Text;
open;
end;
begin
close;
sql.clear;
sql.add('SELECT * FROM table ');
sql.add('WHERE Qfield= :Qpara');
Parameters.ParaByName('Qpara').Value := Edit1.Text;
open;
end;