Question update database record?

[kreuznach]

i have a problem updating database using update query..
here i have a table name STOCK with column: "itemID" (primary key), "itemName" (text), "itemAvailable" (integer)

i have textbox "txtItemID", and button "Process"

all i want is, if i type itemID in the text box and hit "Process" button, typed item ID "itemAvailable" will be reduced by one..

i create update query like this: "UPDATE STOCK SET itemAvailable = itemAvailable - 1 WHERE itemID = '"& txtItemID &"'"
but it didn't work...

will somebody kindly show me the right query for updating? thanks in advance...

 

[kulrom]

try this:

Dim sql As String ="UPDATE STOCK SET itemAvailable = itemAvailable - 1 WHERE itemID = " & txtItemID.Text & ""

Notice that i removed the single quotes '" & txtItemID & "' should be " & txtItemID & "

 

[kulrom]

Also i added .Text after txtItemID. You must use its text property instead.

If it's not numeric column then return the single quotes back and try again.