ACCESS ADO Á¬±í²éѯ recordset->update ???

»ù±¾µãÈçÌâ
hr = m_pConnection->Open(_bstr_t(m_connectionStr),"","",adEditNone);
////
CString  sqlquery;
sqlquery.Format("select * from scores,students where students.studentid =scores.stdnumber and scores.subjectid=%d",subjectid);
_variant_t sql=sqlquery;
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open(sql,_variant_t((IDispatch*)m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
return m_pRecordset;
/////
m_pRecordset->AddNew();
m_pRecordset->PutCollect("studentname",vstudentname);
m_pRecordset->PutCollect("studentid",vstudentnumber);
m_pRecordset->PutCollect("scorecontent",vscore);
m_pRecordset->Update();

Ö´Ðе½update¾Í²»ÐÐÁË,ÎÒµÄÄ¿µÄÊÇÖ»½«¼Ç¼·Åµ½¼Ç¼¼¯ÖÐ,ÉÏÃæ´ò¿ªÁ¬½ÓµÄʱºòÓÃadEditNone²»ÖªµÀ¶Ô²»¶Ô,¿´±ðÈË˵ÕâÑù,ÓÃupdate²»»áÖ±½Óµ½Êý¾Ý¿âÁË,ÒªÓõ½updatebatch();
´óϺ°ï°ï,VC++²ËÄñ

---

ÍüÁ˲¹³ä,µ¥±íµÄ²Ù×÷¶¼¿ÉÒÔ°É

---

ΪʲôûÈË°ïÎÒ= =¶¼Ã»ÓÐÓöµ½¹ýÂð

---

Ò»°ãÎÒ²»»á¶Ô¶à±íÓÃm_pRecordset->Update(); Ö±½ÓÓÃSQLµÄupdateÓï¾ä¡£Èç¹ûÒ»¶¨ÒªÓ㬾ÍÓÃview°É

---

m_pRecordset->AddNew();
m_pRecordset->PutCollect("studentname",vstudentname);
m_pRecordset->PutCollect("studentid",vstudentnumber);
m_pRecordset->PutCollect("scorecontent",vscore);
m_pRecords