1
Answer

incorrect SELECT statement

What is wrong with my code?


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 :((

Answers (1)