我正在用VB编程，在修改信息时出现如下问题：

来源：百度知道 编辑：UC知道 时间：2024/05/01 05:51:33
SQL = "update 服饰表 set" _
"产品名称"= " & Text2.Text & ", _
& 品牌= & "'" & Text3.Text & "'," _
& 进价= & "'" & Text4.Text & "'," _
& 售价= & "'" & Text5.Text & "'," _
& 尺码= & "'" & Text6.Text & "'," _
& 所在地= & "'" & Text7.Text & "'," _
& 库存= &"'" & Text8.Text & "'," _
& 备注= & "'" & Text9.Text & "'," _
& 款式= & "'" & Combo1.Text & "'"
cnn.Execute SQL
老是格式出错，我搞不懂，懵了！即使格式对了，也说我列前缀与表不匹配
谢谢各位帮忙看下！

SQL = "update 服饰表 set" _
& " 产品名称='" & Text2.Text & "'," _
& "品牌='" & Text3.Text & "'," _
& "进价='" & Text4.Text & "'," _
& "售价='" & Text5.Text & "'," _
& "尺码='" & Text6.Text & "'," _
& "所在地='" & Text7.Text & "'," _
& "库存='" & Text8.Text & "'," _
& "备注='" & Text9.Text & "'," _
& "款式='" & Combo1.Text & "'"

分行写是好习惯，但要看清楚。该加空格的地方一定要加，不该加&、"的地方一定不能加

SQL = "update 服饰表 set" & _
"产品名称= '" & Text2.Text & _
"品牌= '" & Text3.Text & "'" _
& "进价= '" & Text4.Text & "'" _
& "售价='" & Text5.Text & "'" _
& "尺码= '" & Text6.Text & &quo