1
Answer

incorrect SELECT statement

mohamad guntur

mohamad guntur

11y
1.6k
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)