Question

标准表达式中数据类型不匹配ACCESS

Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
Dim deletstr As String = TextBox2.Text
Dim sqlString As String = " delete from 测试项目表 where NUM=" & deletstr

'Try
Dim myConn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= d:\access\NewMDB.mdb")
myConn.Open()
Dim inst As OleDbCommand = New OleDbCommand(sqlString, myConn)
inst.ExecuteNonQuery()
myConn.Close()
'Catch ex As Exception
'MsgBox(ex.Message)
'End Try
End Sub

Answer 1

delete from 测试项目表 where NUM=" & deletstr

对于ACCESS的SQL语句， 条件中数字不加引号， 字符串加单引号， 日期两端加#号

你这个NUM是不是数字？ 如果是数字就肯定错

追问

NUM不是变量是字段的名字
但是字段下面的内容是数字
你的意思是字段文本类型是吧，
我里面是数字，我定义的是TEXT
我知道了，你提醒我了
Dim sqlString As String = " delete from 测试项目表 where NUM=""" & deletstr & """"
这样就可以了