INSERT INTO语句中的语法错误. (VB和ACCESS 2013) [英] Syntax error in INSERT INTO statement. (VB and ACCESS 2013)

问题描述

原谅我问这个愚蠢的问题，但是... 我真的不知道如何解决此语法错误

Forgive me for asking this stupid question but... I really cannot figure out how to solve this syntax error

在我的数据库(访问权限为2013)中，我的表中有此字段

In my database(which is access 2013) I have this fields in my table

字段-数据类型

否-数字

排名-短文本

姓氏-短文本

名字-短文本

中间名-短文本

地址-短文本

联系人号码-短文本

ACCNT代码-短文本

ACCNT CODE - Short Text

单位代码-数字

ATM ACCNT NUMBER-号码

ATM ACCNT NUMBER - Number

笔名-短文本

备注-短文本

这是我的代码:

Imports System.Data.OleDb

Public Class Form2

Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
    Dim con As New OleDbConnection
    con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Retiree.accdb"

    Dim cmd As New OleDb.OleDbCommand
    If Not con.State = ConnectionState.Open Then
        con.Open()
    End If
    cmd.Connection = con


    cmd.CommandText = "INSERT INTO Retiree(NO, RANK, [LAST NAME], [FIRST NAME], [MIDDLE NAME], ADDRESS, [CONTACT NUMBER], [ACCNT CODE], [UNIT CODE], [ATM ACCNT NUMBER], [PENSION TYPE], REMARKS) VALUES(399, 'dfdGDFGF', 'GwejjweDFGF', 'GDfgfgFGF', 'GDFGfgfF', 'GDFfdftertGF', 'GfgdfggfgfgDFGF', 'GdfggfdgvbvDFGF', 1323, 2132, 'GDFgdsfbvsdGF', 'GDsgdfsjjjFGF')"

    cmd.ExecuteNonQuery()
    con.Close()
    Me.Close()


End Sub


End Class

我收到的错误消息是: INSERT INTO语句中的语法错误.

The error message I get is: Syntax error in INSERT INTO statement.

我希望有人能指出我代码中的语法错误，因为我真的不知道它在哪里.(也许我的视力现在真的很差)

I hope someone can point out the syntax error in my code because I really cannot figure out where is it.(Maybe my eyesight is really bad now)

推荐答案

尝试使用此功能.所有列名称都放在[]括号中.因为No是保留字，所以可能存在问题，它应该在[]内部.

Try to use this. All column names put In [] brackets. There can be issue that because No is reserved word, It should be inside [].

 cmd.CommandText = "INSERT INTO Retiree([NO], [RANK], [LAST NAME], [FIRST NAME], [MIDDLE NAME], [ADDRESS], [CONTACT NUMBER], [ACCNT CODE], [UNIT CODE], [ATM ACCNT NUMBER], [PENSION TYPE], [REMARKS]) VALUES(399, 'dfdGDFGF', 'GwejjweDFGF', 'GDfgfgFGF', 'GDFGfgfF', 'GDFfdftertGF', 'GfgdfggfgfgDFGF', 'GdfggfdgvbvDFGF', 1323, 2132, 'GDFgdsfbvsdGF', 'GDsgdfsjjjFGF')"

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