UPDATE语句(VB.NET)中的语法错误 [英] Syntax error in UPDATE statement (VB.NET)

问题描述

大家好，
我正在使用VB.net(2010)，并且尝试更新Accedss 2010数据库.
我收到以下错误消息:
cmd.ExecuteNonQuery()statemant处UPDATE语句中的语法错误.
我的代码如下:

Hi All,
I am using VB.net (2010) and I am trying to update a Accedss 2010 DB.
I am getting the following erroe:
Syntax error in UPDATE statement at the cmd.ExecuteNonQuery() statemant.
My code is as follows:

Dim Username As String
   Dim ComputerName As String
   Dim AccessTime As Date
   Dim AppName As String
   Dim DomainName As String
   Dim ProjectRef As String

   Dim Update As String = _
  "Update Application Logging set (AccessTime,UserName, ComputerName, DomainName, AppName, ProjectRef) Values(?,?,?,?,?,?)"
   Dim cnnString As String = _
   "Provider = Microsoft.ACE.OLEDB.12.0; Data Source = \\appserver\database.accdb; "


   Public Sub DBUpdate()
       Username = System.Security.Principal.WindowsIdentity.GetCurrent.Name
       DomainName = Environment.UserDomainName
       ComputerName = Environment.MachineName
       AccessTime = Date.Now
       AppName = My.Application.Info.AssemblyName


       Using cnn As New OleDbConnection(cnnString)
           cnn.Open()
           Using cmd As New OleDbCommand(Update, cnn)
               cmd.Parameters.AddWithValue("AccessDate", AccessTime)
               cmd.Parameters.AddWithValue("Username", Username)
               cmd.Parameters.AddWithValue("ComputerName", ComputerName)
               cmd.Parameters.AddWithValue("DomainName", DomainName)
               cmd.Parameters.AddWithValue("AppName", AppName)
               cmd.Parameters.AddWithValue("ProjectRef", ProjectRef)

               cmd.ExecuteNonQuery()

           End Using

       End Using

我对此并不陌生，所以我确定这是我的一个简单错误.

感谢您的帮助.

I''m new to this so I''m sure its a simple mistake on my part.

Thanks for any help.

推荐答案

Application Logging中的空格是您的问题-用引号或方括号括起来(不确定喷气机的要求)

the space in Application Logging is your problem - enclose it in quotes, or square brackets (not sure of jet''s requirements)

这篇关于UPDATE语句(VB.NET)中的语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！