sqlÃüÁîµÄÎÊÌâ

  QryTmp:=TADOQuery.Create(self);
  QryTmp.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+extractfilepat(application.ExeName)+'db.mdb;Persist Security Info=False';
  QryTmp.Close;
  QryTmp.SQL.Clear;
  QryTmp.SQL.Add('select * from mudb where id = '''+js+''' ');
(js¶¨ÒåµÄString¸ñʽ)
Ôõô×ÜÌáʾ¸ñʽ²»¶Ô??  ID ÊDZíÖÐ ×Ô¶¯±àºÅµÄ,  ÒªÔõôдÕâ¸öSQL?  ÒÔ×Ô¶¯±àºÅµÄÊý¾Ý×÷ΪÌõ¼þ

---

QryTmp.SQL.Add('select * from mudb where id = '+js);

---

'select * from mudb where id = '+js

---

ÒýÓÃ

QryTmp.SQL.Add('select * from mudb where id = '+js);

ÎÒÓÃÁË,Ìáʾ²Ù×÷·û¶ªÊ§ ÔÚ±í´ïʽ'id= 'ÖÐ

---

Delphi(Pascal) code:
QryTmp.SQL.Add('select * from mudb where id = '+strtoint(js)+'');

ÊÔÊÔÕâ¸ö

---

delphi 7  ±àÒ붼²»ÄÜͨ¹ý,  'String' and 'Integer' µÄ´íÎó

---

ÒýÓÃ

ÒýÓà 1 Â¥ sparklerl µÄ»Ø¸´:
QryTmp.SQL.Add('select * from mudb where id = '+js);

ÎÒÓÃÁË,Ìáʾ²Ù×÷·û¶ªÊ§ ÔÚ±í´ïʽ'id= 'ÖÐ

jsΪ¿ÕÔì³ÉµÄ

Delphi(Pascal) code

---

Code highlighting produced by Actipro CodeHighli