Member Avatar for joshslaton 
ODBC_COM = New OdbcCommand("UPDATE President SET '" & President_UPDATE_field.Text & "'='" & President_UPDATE_text.Text + "'", ODBC_CON)
        ODBC_COM.ExecuteNonQuery()

i dont know why im having error like this, what i know is my syntax for UPDATE command is correct and im using correct number of single quotes and double quotes

  • 2 Contributors
  • 1 Reply
  • 89 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Oxiegen
Member Avatar for Oxiegen

Close, but no cigar.
Try it like this instead.
Notice that I removed some single-quotes and changed the plus-sign (+) into an ampersand (&).

ODBC_COM = New OdbcCommand("UPDATE President SET " & President_UPDATE_field.Text & " = '" & President_UPDATE_text.Text & "'", ODBC_CON)
ODBC_COM.ExecuteNonQuery()

Also. If you put it all inside a Try...Catch statement, you can put a MessageBox.Show(ex.ToString) inside the Catch to see what's going on if an error occurs.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.