窗口出现了这个错误提示,是不是我的这段代码有问题?
窗口的计时器代码如下:
Dim s As String = Date.now()
Dim cmd As New SQLCommand
cmd.C
cmd.CommandText = "Update {账户管理} Set [最近在线] = '" & s & "' where [用户账号] = '" & Vars("登陆用户") & "'"
If cmd.ExecuteNonQuery = 1 Then
End If
.NET Framework 版本:2.0.50727.3643
Foxtable 版本:2012.11.21.1
错误所在事件:
详细错误信息:
System.Data.OleDb.OleDbException: 操作必须使用一个可更新的查询。
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at Foxtable.SQLCommand.ExecuteNonQuery()
[此贴子已经被作者于2012-11-20 14:52:04编辑过]