读书人

SQL的UPDATE话语无法执行

发布时间: 2011-12-07 22:35:48 作者: rapoo

SQL的UPDATE语句无法执行?
Dim str As String = "Update Dir2 Set Check = '0 ' Where 路径= 'NOW ' "
Dim mycom As New OleDbCommand(str, mycon)
mycom.ExecuteNonQuery()

为何上述语句运行出错?(访问mdb文件)

[解决办法]
将 "check " 用 "[] "括住看下
Dim str As String = "Update Dir2 Set [Check] = '0 ' Where 路径= 'NOW ' "

读书人网 >VB Dotnet

热点推荐