INSERT INTO 语句的问题 [英] Trouble with INSERT INTO statement

问题描述

我似乎无法弄清楚为什么我不断收到 INSERT INTO 语句中的语法错误.

I can't seem to figure out why I keep getting a Syntax error in INSERT INTO statement.

代码如下.

static void ABSChangeEventsTable(string ControlNumber, string CurrentStatus)
{
   using (var connection = new OleDbConnection(strAccessConnAbstracting))
   using (var command = connection.CreateCommand())
   {
      connection.Open();               

      command.CommandText = "INSERT INTO Events (Date_Time, Details, Regarding, User, Control_Number) VALUES (@Date_Time, @Details, @Regarding, @User, @Control_Number)";

      command.Parameters.AddWithValue("@Date_Time", DateTime.Now);
      command.Parameters.AddWithValue("@Details", "OLD:"+CurrentStatus+" NEW: Received Fax");
      command.Parameters.AddWithValue("@Regarding", "Status Changed");
      command.Parameters.AddWithValue("@User", "System");
      command.Parameters.AddWithValue("@Control_Number", ControlNumber);

      try
      {
         command.ExecuteNonQuery();
      }
      catch (System.Exception ex)
      {                   
         throw;
      }
   }            
}

推荐答案

User是保留关键字，需要用方括号括起来:

User is a reserved keyword, you need to wrap it in square brackets:

INSERT INTO Events (Date_Time, Details, Regarding, [User], Control_Number) VALUES (@Date_Time, @Details, @Regarding, @User, @Control_Number)

我建议重命名该列以避免每次引用时都需要方括号.

I'd recommend renaming that column to avoid the need for square brackets every time you reference it.

这篇关于INSERT INTO 语句的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！