Private Sub 删除_Click() Dim mycom As New ADODB.Command
Dim count As Long
Dim constr, sql As String
Set con = New ADODB.Connection
Set rst = New ADODB.Recordset
Set mycom = New ADODB.Command constr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=I:\毕设5.20\db1.mdb; Persist Security Info=False "
con.Open constr
If con.State = adStateOpen Then
MsgBox "打开数据库"
End If
Set mycom.ActiveConnection = con
'调用查询函数查询出要删除的记录
Call 查询_Click sql = "delete from author where " & strWhere & ""
MsgBox (sql)
mycom.CommandText = sql
MsgBox ("删除成功")
rst.Open mycom, , adOpenStatic, adLockOptimistic Set con = Nothing
End Sub
可以查询出要删除的记录,并在子窗体中显示,但rs.RecordCount却为0,通过delete对数据表进行操作也无效!各位大哥大姐帮帮忙,很着急。
Dim count As Long
Dim constr, sql As String
Set con = New ADODB.Connection
Set rst = New ADODB.Recordset
Set mycom = New ADODB.Command constr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=I:\毕设5.20\db1.mdb; Persist Security Info=False "
con.Open constr
If con.State = adStateOpen Then
MsgBox "打开数据库"
End If
Set mycom.ActiveConnection = con
'调用查询函数查询出要删除的记录
Call 查询_Click sql = "delete from author where " & strWhere & ""
MsgBox (sql)
mycom.CommandText = sql
MsgBox ("删除成功")
rst.Open mycom, , adOpenStatic, adLockOptimistic Set con = Nothing
End Sub
可以查询出要删除的记录,并在子窗体中显示,但rs.RecordCount却为0,通过delete对数据表进行操作也无效!各位大哥大姐帮帮忙,很着急。
解决方案 »
- WORD的RANGE问题
- 如何能关连并绑定两个以上exe程序?
- 请问;我给button控件picture属性设置了一幅图片,但是如何取消图片?
- 请问一个在INTERNET上的远端客户,当他运行程序时,如何去确定到底客户....
- 如何隐藏和显示WebBrowser控件?
- 怪事,文件下载的问题URLDownloadToFileA
- 工作还是没有着落
- 如何获取IE地址栏里的地址
- 用datagrid控件修改数据库,如果某项定义为数字,输入为字符,就弹出:多步操作产生错误。请检查每一步状态,我如何捉到这个错误,让它显
- 请问各位大哥大姐有没有局域网点对点传送文件的工具??????
- 关于PlgBlt旋转图像问题
- VB加载DLL中遇到的问题
Dim mycom As New ADODB.Command
Dim count As Long
Dim constr, sql As String
Set con = New ADODB.Connection
Set rst = New ADODB.Recordset
Set mycom = New ADODB.Command
constr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=I:\毕设5.20\db1.mdb; Persist Security Info=False "
con.Open constr
If con.State = adStateOpen Then
MsgBox "打开数据库"
End If
Set mycom.ActiveConnection = con
'调用查询函数查询出要删除的记录
Call 查询_Click
sql = "delete from author where " & strWhere & ""
MsgBox (sql)
con.Execute sql
MsgBox ("删除成功")
Set con = Nothing
End Sub
sql = "delete from author where " & strWhere & ""
MsgBox (sql)
con.Execute sql, AffectedRecords
MsgBox ("删除" & AffectedRecords & "条记录")
在 Execute 方法中,如果没有符合 Where 子句条件的记录,并不会返回错误,只是没有删除或更新任何记录而已。