1 Reply Latest reply on Mar 31, 2010 12:22 PM by Mystick

    Update statement in VB.NET help!

    ISTMajor

      Title

      Update statement in VB.NET help!

      Post

      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

       

      conn.Open()

       

       

       

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

       

       

      comm.ExecuteNonQuery()

       

      conn.Close()