DELPHI´ó¼Ò°ïæ¿´ÏÂÕâ¶Î´úÂëÄÄÀï´íÁË£¿

procedure TForm7.ds1DataChange(Sender: TObject; Field: TField);
var
temp1:string;
begin
  temp1:=edit1.text;
  if (temp1 <>'') then
  begin
  ADOQuery3.close;
  ADOQuery3.sql.clear;
  ADOQuery3.sql.add('select * from ±í1 where temp1');
  ADOQuery3.open;
  end;
  ds1.DataSet:=ADOQuery3;
  DBGrid1.DataSource:=ds1;
end;
end.
ÎÒÏë¸ù¾ÝEDIT1.TEXTËùÏÔʾµÄÊý¾Ý£¬Í¨¹ýËÑË÷È»ºóÏÔʾÔÚDBGridÉÏ

---

Ìù³ö´íÎóÃèÊö£¬
ÁíÍâ'select * from ±í1 where temp1' ɶÒâ˼£¬¶ÔÊý¾Ý¿â²»ÔõôÊìϤ

---

ADOQuery3.sql.add('select * from ±í1 where '+temp1);

---

ÕâÊÇds1 DataÖµÉú±ä»¯²Å»á´¥·¢´Ëʼþ

ÈôÏë¸ù¾ÝeditÄÚÈݸı伴ʱ·´Ó³³ö½á¹û,¾ÍÓ¦¸Ã·ÅÔÚedit onchangeʼþÖÐ

»¹ÓÐÕâ¸öÔÚÔËÐÐʱ»á³ö´íµÄ:
select * from ±í1 where temp1

¿É¸ÄΪ:
select * from ±í1 where kk='+Quotedstr(temp1)

---

select * from ±í1 where temp1
ûÓвÎÊýµÄ£¬ÕâÑùд²»¶Ô°É

---

ADOQuery3.sql.add('select * from ±í1 where ×Ö¶ÎÃû³Æ = '''+temp1+''' ');

---

ADOQuery3.sql.add('select * from ±í1 where ±í1ij×Ö¶Î='+temp1);

---

sqlÓï¾äÓÐÎÊÌâ

---

ÒýÓÃ

ADOQuery3.sql.add('select * from ±í1 where ±í1ij×Ö¶Î='+temp1);

¼ì²éÕâÀïÊý¾Ý¿â¿´¿´£¨£¬where ±í1ij×Ö¶Î='+temp1);