1
Answer

incorrect SELECT statement

Photo of mohamad guntur

mohamad guntur

12y
2k
1
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)