Error: Syntax error in UPDATE statement

Question

the error i get while executing the code below in OleDb

        Try
            con.Open()
            Dim cmd As New OleDbCommand("Select * from customer", con)
            cmd.CommandText = " update customer set hr =@hr,min =@min "
            cmd.Parameters.AddWithValue("@hr", ComboBoxHr.SelectedIndex.ToString())
            cmd.Parameters.AddWithValue("@min", ComboBoxMin.SelectedIndex.ToString())
            cmd.ExecuteNonQuery()
            TwoDigit(ComboBoxHr)
            MessageBox.Show("CONRATULATIONS! ...Click the Start button to see the changes")
        Catch ex As Exception
            MessageBox.Show(ex.Message.ToString())
        End Try

Which works fine if i remove the "min" part. What could be the reason?

etoisarobot · Accepted Answer · 2010-04-27 15:03:08Z

2

I believe AakashM is right. You can however use a keyword as a column name as long as you put it in [] like

Try
        con.Open()
        Dim cmd As New OleDbCommand("Select * from customer", con)
        cmd.CommandText = " update customer set hr =@hr,[min] =@min "
        cmd.Parameters.AddWithValue("@hr", ComboBoxHr.SelectedIndex.ToString())
        cmd.Parameters.AddWithValue("@min", ComboBoxMin.SelectedIndex.ToString())
        cmd.ExecuteNonQuery()
        TwoDigit(ComboBoxHr)
        MessageBox.Show("CONRATULATIONS! ...Click the Start button to see the changes")
    Catch ex As Exception
        MessageBox.Show(ex.Message.ToString())
    End Try

answered Apr 27, 2010 at 15:03

etoisarobot

7,81417 gold badges57 silver badges84 bronze badges

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

1 Comment

piku Over a year ago

You folks are awesome. PROBLEM SOLVED thanks for saving my a** again :D

AakashM · Accepted Answer · 2010-04-27 14:57:57Z

2

MIN is a keyword in SQL (it's the aggregate function for finding the minimum of a group of values). Either use a different name for your column, or enclose it in [ square brackets ] - I'm not actually sure if this will work in Access, mind...

answered Apr 27, 2010 at 14:57

AakashM

63.5k17 gold badges154 silver badges190 bronze badges

1 Comment

piku Over a year ago

You folks are awesome. PROBLEM SOLVED thanks for saving my a** again :D

Collectives™ on Stack Overflow

Error: Syntax error in UPDATE statement

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related