mohamad guntur

mohamad guntur

  • NA
  • 40
  • 31.3k

incorrect SELECT statement

Nov 15 2012 12:38 AM
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)