query = String.Format("SELECT * FROM PRODUCT WHERE QTY = QTY < " & Me.txtTOTAL_A.Text & "AND ID_PRODUCT = '" & idproduct(0).Trim & "';")
cmd.CommandText = query
cmd.ExecuteNonQuery()
Error:
Incorect syntax near '<'
pls help :((
1 Reply
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Abwaank KhaliifPosted Nov 17, 2012, 12:25 AM
for example write something like this:-
query = String.Format("SELECT * FROM PRODUCT WHERE QTY = " & Me.txtTOTAL_A.Text & " AND ID_PRODUCT = '" & idproduct(0).Trim & "'")
hope this helps you.
Regards
Abkasoft Corporation