VB出学者问
为什么在 update 里添加了 这条控制语句后 会提示 缺少 语句结束标记呢 没添加时 没有问题 请高手指点where ([Year] =" & Combo1.Text & ") and ([Month]=" & Combo2.Text & ")原文:SQLstmt = "Update Data Set Personnel=" & Text1(0).Text & ",Wages=" & Text1(1).Text & ",Communication=" & Text1(2).Text & _",Badtrip=" & Text1(3).Text & ",Automobile=" & Text1(4).Text & ",Rent=" & Text1(5).Text & _",interestexpend=" & Text1(6).Text & ",Invite=" & Text1(7).Text & ",Cannotmeet=" & Text1(8).Text & _",Depreciate=" & Text1(9).Text & ",stand=" & Text1(10).Text & ",Fixedlyxj=" & Text1(11).Text & _",Transportation=" & Text1(12).Text & ",itempraise=" & Text1(13).Text & ",Accommodation=" & Text1(14).Text & _",Changecommunication=" & Text1(15).Text & ",Changeentertainment=" & Text1(16).Text & ",marketexpand=" & Text1(17).Text & _",Adjust=" & Text1(18).Text & ",Taxgold=" & Text1(19).Text & ",costexpenses=" & Text1(20).Text & _",businesstosubsidize=" & Text1(21).Text & ",Handgroupup=" & Text1(22).Text & ",Changexj=" & Text1(23).Text & _",Profits=" & Text1(24).Text & ",Profitmargin=" & Text1(25).Text & ",earnings=" & Text1(26).Text where ([Year] =" & Combo1.Text & ") and ([Month]=" & Combo2.Text & ")
参考答案:& Text1(25).Text & ",earnings=" & Text1(26).Text & " where ([Year] =" & Combo1.Text & ") and ([Month]=" & Combo2.Text & ")
where 前少了 & "