VC6.0ÖÐÓÃADOÁ¬½Óaccess Ö´ÐÐSQLʱ³ö´í

CString strSql = "DELETE from Name_id WHERE order='1' AND ÃÜÂë='123' AND id='1'";
m_pConnection->Execute((_bstr_t)strSql, NULL, adCmdText);

ÕâÑù¾Í»á³öÏÖ´íÎó£¬ÏÂÃæÄÇÑù¾ÍûÎÊÌâ¡£
CString strSql = "DELETE from Name_id";
m_pConnection->Execute((_bstr_t)strSql, NULL, adCmdText);


ÏÂÃæÒ²ÊÇÕâÀàÎÊÌ⣬
  CString strSql="select * from Name_id where order='1'"; 
    BSTR bstrSQL = strSql.AllocSysString(); 
    m_pRecordset->Open(bstrSQL,(IDispatch*)m_pConnection, 
        adOpenDynamic,adLockOptimistic,adCmdText);
´íÎó

  CString strSql="select * from Name_id"; 
    BSTR bstrSQL = strSql.AllocSysString(); 
    m_pRecordset->Open(bstrSQL,(IDispatch*)m_pConnection, 
        adOpenDynamic,adLockOptimistic,adCmdText);
ÕýÈ·


ÎÊÌâ¾Í³öÏÖÔÚSQLÓï¾äÖУ¬¼Ó²»¼ÓwhereºóÃæµÄÏÞÖÆÌõ¼þ

---

±£Áô×ÖID¼Ó[]

---

Ì«¸ÐлÁË£¬½â¾öÎÊÌ⣬ллÁË£¬Ì«ÉÙÓÃÊý¾Ý¿âÀ²£¬µÃºÃºÃѧѧ¡£3Q

---

CString strSql = "DELETE from Name_id WHERE [order]='1' AND [ÃÜÂë]='123' AND id='1'";

ÄãµÄorder ÊÇʲôÀàÐÍ£¿ÁíÍâorder ÊDZ£Áô×Ö£¬ÐèÒª¼ÓÉÏ[]

IDµ¹²»ÊDZ£Áô×Ö¡£