VC++ MFC ODBC应用程序 数据库可以删除,但无法添加和修改记录

void CMyView::OnAppendrecord() 
{
// TODO: Add your control notification handler code here
if (m_IP) 
  OnMove(ID_RECORD_FIRST);
try
{
m_pSet->AddNew();
  }
catch(CDBException* e)
{
  AfxMessageBox(e->m_strError);
  e->Delete();
}
m_IP = TRUE;
  UpdateData(FALSE); 
}

void CMyView::OnDeleterecord() 
{
// TODO: Add your control notification handler code here
  try
{
  m_pSet->Delete();
}
  catch(CDBException* e)
{
  AfxMessageBox(e->m_strError);
  e->Delete();
}
 // END_CATCH
  m_pSet->MoveNext(); 
  if (m_pSet->IsEOF()) 
  m_pSet->MoveLast();
  if (m_pSet->IsBOF()) 
  m_pSet->SetFieldNull(NULL);
  UpdateData(FALSE); 
}

void CMyView::OnEditrecord() 
{
// TODO: Add your control notification handler code here
if (m_IP == TRUE)
{
  m_pSet->Move(AFX_MOVE_REFRESH); 
  m_IP = FALSE;
}
  UpdateData(FALSE);
}


BOOL CMyView::OnMove(UINT nIDMoveCommand) 
{
// TODO: Add your specialized code here and/or call the base class
if (m_IP)
{
  if (!UpdateData())
  return FALSE;
  try
{
  m_pSet->Update();
}
  catch(CDBException* e)
{
  AfxMessageBox(e->m_strError);
  e->Delete();
}
  m_pSet->Requery(); 
  UpdateData(FALSE);
  m_IP = FALSE;
  return TRUE;
}
  else
{
return CRecordView::OnMove(nIDMoveCommand);
}
CRecordset* pSet = OnGetRecordset();

}

添加记录后，表里面没有反应，但是删除的时候有效