更新查询MySQL到VB.net

Question

我试过这个查询在MySQL上，它完美的作品。

UPDATE tblstocklog 
SET quantity = quantity - 5 
WHERE(ProductNo = 25370) 
AND quantity >= 5 
ORDER BY StockNo ASC LIMIT 1 

但是，当我尝试用VB.net它不会更新，也不会给出错误消息。

con3.Open() 

query3 = "UPDATE tblstocklog set Quantity = Quantity - '" & txt_qty.Text & _ 
"' WHERE (ProductNo = '" & txt_pno.Text & _ 
"') AND Quantity >= '" & txt_qty.Text & "' ORDER by StockNo ASC LIMIT 1" 

Dim cmd3 As MySqlCommand = New MySqlCommand(query, con3) 
Dim i3 As Integer = cmd3.ExecuteNonQuery() 
con3.Close() 

Answer 1

对不起，我很急于做我的程序，我错过了一个明确的错误。

Dim cmd3 As MySqlCommand = New MySqlCommand(**query**, con3) 

查询应该是QUERY3