AnsweredAssumed Answered

Update statement in VB.NET help!

Question asked by ISTMajor on Mar 31, 2010
Latest reply on Mar 31, 2010 by Mystick


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))