这段UPDATE有错吗

来源：百度知道 编辑：UC知道 时间：2024/05/19 19:02:41
sql = "update userinf set "
sql = sql & "password=" & SqlStr(password) & ", "
sql = sql & "name=" & SqlStr(name) & " where username=" & sqlstr(oabusyusername)
加上单引号了,还是不成

错了 在sql语句中字符串是要被单引号括起来的 应该是
sql = "update userinf set "
sql = sql & "password='" & SqlStr(password) & "', "
sql = sql & "name='" & SqlStr(name) & "' where username='" & sqlstr(oabusyusername) & "'"

sql = "update userinf set "
sql = sql & "password= '" & SqlStr(password) & "', "
sql = sql & "name= '" & SqlStr(name) & "' "
sql = sql & "where username='" & sqlstr(oabusyusername)&"'"

你单引号漏了，这样试试看

sql = "update [userinf] set "
sql = sql & "password='" & SqlStr(password) & "', "
sql = sql & "name='" & SqlStr(name) & "' where username='" & sqlstr(oabusyusername) & "'"

sql = "update [userinf] set "
sql = sql & "[password]='" & Sq