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)

Help with impersonation in referenced DLL