读书人

CDaoRecordSet delete 出错. 急解决

发布时间: 2012-01-26 19:40:46 作者: rapoo

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的参数不对,不要只读!

读书人网 >VC/MFC

热点推荐