查询access的数字类型

select * from table where [pname]='''+edit1.text+'''  不好用

---

'select * from table where [pname]='+QuotedStr(edit1.text)
如果字段是数字型的
'select * from table where pname='+edit1.text

---

字符
str:='select * from table where [pname]='''+edit1.text+'''';
数字
str:='select * from table where [pname]='+edit1.text;

---

query.sql.add('select * from table where pname=0');这样在access数据查询不行