Incorrect SQL syntax error

Question

I have a SQL statement to delete a record from a database table. After stepping through it, I can see that it all works correctly, except for the final part (that is to say, it correctly gets the desired row to delete and all variables match the values that they should be). I'm new to using SQL, so can anybody tell me how to fix the following error at all?

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll

Additional information: Incorrect syntax near '*'.

SQL query:

Public Shared Sub deleteRecord(ByVal recordID As Integer, con As OleDbConnection)
    Dim Dc As New OleDbCommand
    Dc.Connection = con

    con.Open()
    Dc.CommandText = "DELETE * FROM tblData WHERE([recordID] =  '" & recordID & "')"

    Dc.ExecuteNonQuery()
    con.Close()

End Sub

Get rid of the *. Syntax is DELETE FROM [TABLE] WHERE [FILTERS] — Aaron Dietz
– Aaron Dietz, Commented Jul 13, 2016 at 15:09
Copy past your query and try it directly in the database... The error tells you the problem, remove the star. — the_lotus
– the_lotus, Commented Jul 13, 2016 at 15:10
You should use parameterised queries. Whilst the int prevents SQL injection you are still potentially bloating the plan cache with single use queries. — Martin Smith
– Martin Smith, Commented Jul 13, 2016 at 15:14
@einpoklum Yes I approved the edit as the code was a vb.net function I made on the delete button click, it had nothing to do with the error I was asking about — user6579928
– user6579928, Commented Jul 13, 2016 at 15:21

Gilad Green · Accepted Answer · 2016-07-13 16:18:43Z

3

Just remove the * and the parentheses. DELETE FROM tblData WHERE recordID = ...

edited Jul 13, 2016 at 16:18

Gilad Green

37.3k7 gold badges67 silver badges99 bronze badges

answered Jul 13, 2016 at 15:10

StackOverflowGuest

411 bronze badge

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

Comments

Dimitri · Accepted Answer · 2016-07-13 15:10:03Z

1

replace with this:

Dc.CommandText = "DELETE FROM tblData WHERE [recordID] = " & recordID

answered Jul 13, 2016 at 15:10

Dimitri

7,0534 gold badges38 silver badges50 bronze badges

Comments

Aaron Dietz · Accepted Answer · 2016-07-13 15:16:08Z

1

* is used in lieu of typing out all of the column names you want to SELECT. The important thing to note here is that it represents columns.

DELETE occurs against rows. Therefore, saying DELETE * does not make any sense. You can't delete single columns/cells in this way.

Correct syntax is DELETE FROM [TABLE] WHERE [FILTERS]

answered Jul 13, 2016 at 15:16

Aaron Dietz

10.3k1 gold badge17 silver badges27 bronze badges

Collectives™ on Stack Overflow

Incorrect SQL syntax error

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related