Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
1
Answer
incorrect SELECT statement
mohamad guntur
11y
1.6k
1
Reply
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 :((
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
how to insert images in mysql database
Overload resolution data adapter?