Private Sub Command18_Click()
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim StrSql As String
cnn.Open "provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:database password=;data source=" & App.Path & "\208client.mdb"
StrSql = "delete 208client where cInstallPhone = '" & Trim$(DataCombo6.Text) & "'"
rs.Open StrSql, cnn, adOpenKeyset, adLockBatchOptimistic
End If
End Sub提示
实时错误,'-2147217900 (80040e14)':
语法错误(操作符丢失),在查询表达式'208client where cInstallPhone = '7777777''中。
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim StrSql As String
cnn.Open "provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:database password=;data source=" & App.Path & "\208client.mdb"
StrSql = "delete 208client where cInstallPhone = '" & Trim$(DataCombo6.Text) & "'"
rs.Open StrSql, cnn, adOpenKeyset, adLockBatchOptimistic
End If
End Sub提示
实时错误,'-2147217900 (80040e14)':
语法错误(操作符丢失),在查询表达式'208client where cInstallPhone = '7777777''中。
rs.Open StrSql, cnn, adOpenKeyset, adLockBatchOptimistic
End If改为:
StrSql = "delete from [208client] where cInstallPhone = '" & Trim$(DataCombo6.Text) & "'"
cnn.execute strsql
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim StrSql As String
cnn.Open "provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:database password=;data source=" & App.Path & "\208client.mdb"
StrSql = "delete 208client where cInstallPhone = '" & Trim$(DataCombo6.Text) & "'"
cnn.execute strsql
End If
End Sub
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim StrSql As String
cnn.Open "provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:database password=;data source=" & App.Path & "\208client.mdb"
StrSql = "delete from 208client where cInstallPhone = '" & Trim$(DataCombo6.Text) & "'"
cnn.execute strsql
End If
End Sub
你可以看一下你的sql 语句
where cInstallPhone ='"&trim(DataCombo6.text) &"'