总是报错,在查询视图里面试过了,sql语句没有问题,可就是报错
Private Sub cmdOk_Click() If Trim(txtPassword) <> Trim(txtCompare) Then
MsgBox "两次输入的密码不相符!", vbCritical, "错误"
Exit Sub
End If
strSql = "update administrators set password='" & Trim(txtPassword) & "'where administrator='" & Trim(txtUser) & "'"
On Error GoTo Errorhandle
conn.Execute strSql
Exit SubErrorhandle: MsgBox "执行操作出错,原因:" & Err.Description & Err.Number, vbCritical, "错误"
End Sub
Private Sub cmdOk_Click() If Trim(txtPassword) <> Trim(txtCompare) Then
MsgBox "两次输入的密码不相符!", vbCritical, "错误"
Exit Sub
End If
strSql = "update administrators set password='" & Trim(txtPassword) & "'where administrator='" & Trim(txtUser) & "'"
On Error GoTo Errorhandle
conn.Execute strSql
Exit SubErrorhandle: MsgBox "执行操作出错,原因:" & Err.Description & Err.Number, vbCritical, "错误"
End Sub
where前面要加空格!!!
就是将生成的SQL语句放到数据库中执行一下
其实检查SQL语句最简单的方法
就是将生成的SQL语句放到数据库中执行一下____________________________
你打印一下debug.print strSql
看看语句是什么再检查不就简单多了吗?