Syntax error in insert into statement - in VB.NET

Question

I am trying to insert a record into MS Access db, with the below code. I have used the same type of code several times in my project. But I dont know why it is erroring , saying that there is a syntax error. Some one please suggest me where the code is wrong.

Try
                If MainForm.con.State = ConnectionState.Closed Then
                    MainForm.con.Open()
                End If
                Dim cmdText As String
                cmdText = "insert into tblBottling(bottlingDate,workerName,seed,size,noOfBottles,timeTaken,remarks) values(?,?,?,?,?,?,?)"
                Dim command As OleDbCommand = New OleDbCommand(cmdText, MainForm.con)

                command.Parameters.AddWithValue("@bottlingDate", botDate.Value.ToString("dd-MM-yy"))
                command.Parameters.AddWithValue("@workerName", workerCB.SelectedItem.ToString)
                command.Parameters.AddWithValue("@seed", seedCB.SelectedItem.ToString)
                command.Parameters.AddWithValue("@size", botSizeCB.SelectedItem.ToString)
                command.Parameters.AddWithValue("@noOfBottles", CInt(noOfBot.Text))
                command.Parameters.AddWithValue("@timeTaken", timeTakenTxt.Text)
                command.Parameters.AddWithValue("@remarks", remarksTxt.Text)

                command.ExecuteNonQuery()
                MainForm.con.Close()

            Catch ex As Exception
                MsgBox(ex.ToString)
            End Try

Steve · Accepted Answer · 2017-07-29 11:37:10Z

2

Size is a reserved keyword for MS-Access. If you want to use that word as column name then you should always enclose it between square brackets

cmdText = "insert into tblBottling
          (bottlingDate,workerName,seed,[size],noOfBottles,timeTaken,remarks) 
          values(?,?,?,?,?,?,?)"

answered Jul 29, 2017 at 11:37

Steve

217k22 gold badges242 silver badges296 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dawud Abdul Manan · Accepted Answer · 2017-07-29 12:04:57Z

0

`cmdText = "insert into tblBottling([bottlingDate],[workerName],[seed],[size],[noOfBottles],[timeTaken],[remarks]) values(?,?,?,?,?,?,?)"

Please always use square brackets for your columns incase of such error.

Because you cannot memorise all the keywords.

Good Luck

answered Jul 29, 2017 at 12:04

Dawud Abdul Manan

2324 silver badges8 bronze badges

Comments

Sultan Alkheel · Accepted Answer · 2024-11-09 08:06:12Z

0

try to change the columns names when you create tables avoiding keywords like username like i did 😅

answered Nov 9, 2024 at 8:06

Sultan Alkheel

1

1 Comment

RivenSkaye Over a year ago

Please add in some details about the what. Consider a reference to a list of reserved names and keywords

Collectives™ on Stack Overflow

Syntax error in insert into statement - in VB.NET

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related