UC知道帮忙看看哪错了?谢谢
来源：百度知道 编辑：UC知道 时间：2024/05/29 04:30:30
Dim updateCommand As New OleDbCommand("UPDATE Employee SET " & _
"EmployeeID = '" & id & "', " & _
"PassWord = '" & password & "' " & _
"WHERE UserName = '" & name & "'", UpdateEmployee)
提示说UPDATE的语句语法错误,请大家帮忙看看!!!!!!
"EmployeeID = '" & id & "', " & _
"PassWord = '" & password & "' " & _
"WHERE UserName = '" & name & "'", UpdateEmployee)
提示说UPDATE的语句语法错误,请大家帮忙看看!!!!!!
感觉上没错.
试试下面的形式.我记得sql语句的字符串也要用""来标识的,而你用了单引号,所以不行
dim strsql as string
strsql="UPDATE Employee SET EmployeeID=" & """
strsql=strsql & id
strsql=strsql & """ &",PassWord='"
strsql=strsql & password
strsql=strsql & """ &" WHERE UserName=" &"""
strsql=strsql & name
strsql=strsql & """
dim updateCommand As New OleDbCommand
updateCommand(strsql,Update)
"EmployeeID = " & " & id & " & ", " & _
"PassWord =" & " & password & "& ‘ & _
"WHERE UserName = " & " & " & name & "& ",