本文介紹了INSERT INTO 語句的問題的處理方法，對大家解決問題具有一定的參考價值，需要的朋友們下面隨著小編來一起學習吧！
問題描述
限時送ChatGPT賬號..
我似乎無法弄清楚為什么我不斷收到 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 語句的問題的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！
【網站聲明】本站部分內容來源于互聯網,旨在幫助大家更快的解決問題，如果有圖片或者內容侵犯了您的權益，請聯系我們刪除處理，感謝您的支持！