**用VC++6.0建立了一个“修改密码”对话框,数据源ODBC,表为access,运行时没有报错,但修改密码时报错。F5运行后如图所示:void CRecordset::Edit()
{
ASSERT_VALID(this);
ASSERT(m_hstmt != SQL_NULL_HSTMT);
// we can't construct an UPDATE statement w/o any columns
ASSERT(m_nFields != 0);
代码如下:void CChangePwdDlg::OnOK()
{
CUserSet recordset;
UpdateData(TRUE);
CString strSQL;
strSQL.Format("select*from user where user='%s' AND passwd='%s'",m_UserName,m_OldPwd);
if(!recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
{
MessageBox("打开数据库失败!","数据库错误",MB_OK);
return ;
}
m_recordset.Edit();
m_recordset.m_user=m_UserName;
m_recordset.m_passwd =m_NewPwd1;
m_recordset.Update();
m_recordset.Close();
}
void CChangePwdDlg::OnCancel()
{
// TODO: Add extra cleanup here
CDialog::OnCancel();
}**