在线等待:记录集只读
if(!spdb.IsOpen())
{
//spdb.Open(0,FALSE,FALSE,_T("ODBC;DRIVER=SQL Server;UID=yu;PWD=a123b123;SERVER=mysql"),0);
spdb.OpenEx(_T("DRIVER=SQL Server;UID=yu;PWD=a123b123;SERVER=mysql"),CDatabase::noOdbcDialog);
}
cy12* srs=new cy12(&spdb);
//srs->Open(AFX_DB_USE_DEFAULT_TYPE,_T("Select top 10 * from my_tb where send_ok>0"));
srs->Open(CRecordset::dynamic,_T("Select top 1 * from send_tb where send_ok>0"),CRecordset::none);
srs->Edit();
srs->m_send_ok=0;
srs->Update();
告诉我记录集是只读的,Win2k+SQL2k+Vc6
怎么回事呀