sql - 查询表达式中shortssize = S中字符串的语法错误

Question

我使用此代码更新了MS Access中的条目，但它始终返回错误。我不知道要纠正哪一部分。请帮助我，我似乎找不到错误的部分

Private Sub SaveChanges()
    con.ConnectionString = OpenDBConnection()
    con.Open()
    Dim sql As String = "Update [JobOrderProd] set [CustomerOrderNumber] = 
    '" & CustomerOrderNumtxtbox.Text & "', [ItemNumber] = '" &
        ItemNumbertxtbox.Text & "', [JerseyName] = '" & 
       JerseyNametxtbox.Text & "', [JerseyNumber] = '"`
        & JerseyNumbertxtbox.Text & "', [JerseySize] = '" & 
          JerseySizetxtbox.Text & "', 
        [ShortsSize] = '" & ShortsSizetxtbox.Text
    Dim cmd As New OleDbCommand(sql, con)`enter code here`
    cmd.ExecuteNonQuery()`enter code here`
    con.Close()
    MsgBox("Entry for JO Production has been updated.")
    ClearForm()
End Sub

Answer 1

我认为您最后错过了单个倒逗号。将此添加到& "'"的末尾

JerseySizetxtbox.Text & "', 
[ShortsSize] = '" & ShortsSizetxtbox.Text & "'"