Update statement in VB.NET help!
I'm trying to do a simple update statement.
I call several values using a select statement and want to allow the user to update three others. I keep getting a Parse error as if my statement is incorrect, however; I've checked spelling, commas, etc a dozen times over and still no luck.. please help confirm I'm not over looking some code error I just can't seem to find.
Dim conn As New OdbcConnection
conn.ConnectionString = ConfigurationManager.ConnectionStrings("connWeb").ConnectionString
Dim comm As OdbcCommand
comm = (New OdbcCommand("UPDATE Calltickets_Web SET (Status = '" & StatusDDL.Text & "', Time_To_Finish = '" & TimeDDL.Text & "', Solution = '" & SolutionTxt.Text & "' WHERE Ticket_Number = '" & TicketNumber & "')", conn))
maybe the data inside one of your variable (StatusDDL.Text, TimeDDL.Text, SolutionTxt.Text or TicketNumber)
contains some weird caracters or ' or " and that creates conflicts inside your code.
My advice would be to have a look at the data inside those...