CDaoRecordSet delete 出错. 急...
连接的sqlserver数据库.
m_pMsDb = new CDaoDatabase;
m_pMsDb-> Open(NULL,FALSE,FALSE, _T( "ODBC;DRIVER={SQL Server}; Server=(local); DATABASE = HKDW; UID=admin;PWD=123 "));
if(!m_pMsDb-> IsOpen())
return;
CDaoRecordset rs(m_pMsDb);
CString strRs;
strRs = _T( "select * from Ms_HtmlElement where MS_Id like ' ") + strID + _T( " ' ");
rs.Open(AFX_DAO_USE_DEFAULT_TYPE,strRs,NULL);
if(rs.IsEOF())
return;
while(!rs.IsEOF())
{
rs.Delete();
rs.MoveNext();
}
删除的时候抛出异常 "由于您和其他用户试图同时改变同一数据,
导致MicroSoft Jet 数据库引擎停止进程 "
[解决办法]
Open函数的选项值不正确
[解决办法]
rs.Open的参数不对,不要只读!