updateSQL = "UPDATE numberinfo SET memo = '" & lbl_Memo.Caption & _
"' WHERE orderno = '" & txt_ScanInfo.Text & "'"
上面的代码在执行过程中出现这样的错误: -2147217900 UPDATE语句的语法错误.在线等,谢谢!
"' WHERE orderno = '" & txt_ScanInfo.Text & "'"
上面的代码在执行过程中出现这样的错误: -2147217900 UPDATE语句的语法错误.在线等,谢谢!
updateSQL = "UPDATE numberinfo SET memo = '" & lbl_Memo.Caption & "'"
updateSQL = updateSQL & " WHERE orderno = '" & txt_ScanInfo.Text & "'"
UPDATE语句的语法错误
updateSQL = "UPDATE numberinfo SET numberinfo.memo = '" & lbl_Memo.Caption & _
"' WHERE orderno = '" & txt_ScanInfo.Text & "'"