OpenConn() Dim qqttyy As Integer = Val(ListView1.SelectedItems(0).SubItems(3).Text) Dim codee As String = ListView1.SelectedItems(0).SubItems(1).Text OleDa.UpdateCommand.CommandText = "UPDATE Inventry SET QTY = QTY -'" & qqttyy & "'WHERE CODE ='" & codee & "'" OleDa.UpdateCommand.ExecuteNonQuery() CloseConn()
Jump to Post
I'm not up on data bound controls so I can't speak to that, but the query shouldn't have single quotes around numeric fields. Try
"UPDATE Inventry SET QTY = QTY - " & qqttyy & " WHERE CODE = " & codee
Also, you needed a …
All 6 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.