SQL DELETE statement syntax

Question

Trying to execute a delete query and getting the following error

Syntax error (missing operator) in query expression 'cname VALUES @cname'.

code

Dim conn As OleDbConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & My.Settings.strFileName)
conn.Open()
Dim cmdText = "DELETE FROM products WHERE cname VALUES @cname"
Dim cmd As OleDbCommand = New OleDbCommand(cmdText, conn)
With cmd.Parameters
  .Add(New OleDbParameter("@cname", DataGridView1.Item("cname", i).Value))
End With
Dim dt As New DataTable("products")
cmd.ExecuteNonQuery()
conn.Close()
conn = Nothing

Justin Skiles · Accepted Answer · 2012-08-01 23:28:44Z

4

You need an operator

DELETE FROM products WHERE cname = @cname

answered Aug 1, 2012 at 23:28

Justin Skiles

9,5536 gold badges52 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pacane · Accepted Answer · 2012-08-01 23:34:12Z

3

The way you wrote your delete statement is not correct.

You should write it like this:

Dim cmdText = "DELETE FROM products WHERE cname = @cname"

edited Aug 1, 2012 at 23:34

answered Aug 1, 2012 at 23:29

Pacane

21.7k19 gold badges66 silver badges101 bronze badges

Comments

Aron Jay · Accepted Answer · 2012-08-12 14:49:15Z

-1

And to delete all record from a table with a specific ID, you just have to;

deleteMore:
DELETE TOP(100) TableName WHERE toDelete='17'
IF @@ROWCOUNT != 0
    goto deleteMore:

This will delete the first 100 records, and repeatedly until all records with 17 are gone.

answered Aug 12, 2012 at 14:49

Aron Jay

1555 silver badges11 bronze badges

Collectives™ on Stack Overflow

SQL DELETE statement syntax

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related