SQL DELETE 语句语法 [英] SQL DELETE statement syntax
本文介绍了SQL DELETE 语句语法的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
尝试执行删除查询并得到以下错误
Trying to execute a delete query and getting the following error
查询表达式cname VALUES @cname"中的语法错误(缺少运算符).
Syntax error (missing operator) in query expression 'cname VALUES @cname'.
代码
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
推荐答案
您编写删除语句的方式不正确.
The way you wrote your delete statement is not correct.
你应该这样写:
Dim cmdText = "DELETE FROM products WHERE cname = @cname"
这篇关于SQL DELETE 语句语法的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文