CString sSQL; if(m_database.IsOpen()) 
m_database.Close();
CAppLogSet * m_recordset = new CAppLogSet(&m_database);
m_recordset->Open();
sSQL = "delete * from AppLog";
m_database.ExecuteSQL(sSQL);
m_recordset->Requery();
/* sSQL = "CREATE TABLE winlog ( 日期 VARCHAR(9), 时间 VARCHAR(8),事件类型 VARCHAR(10),事件分类 VARCHAR(10),事件ID VARCHAR(10),事件来源 VARCHAR(10),用户 VARCHAR(10),计算机 VARCHAR(20),事件描述 VARCHAR(200))";
m_database.ExecuteSQL(sSQL);
*/ CString str1,str2;
CStdioFile file("c:\\1.txt",CFile::modeRead);
CString sLine ;
file.ReadString(sLine);
str1 = sLine.Left(sLine.FindOneOf("\t") + 1);
m_recordset->AddNew();
m_recordset->m_eventDate = str1;
m_recordset->m_eventID = "001"; file.ReadString(sLine);
str1 = sLine.Left(sLine.FindOneOf("\t") + 1);
m_recordset->AddNew();
m_recordset->m_eventDate = str1;
m_recordset->m_eventID = "002"; m_recordset->Update();
m_recordset->Requery();///
打开表后,好像只有一条记录.