为什么提示对象关闭时,不允许操作.(帮忙看下代码)

来源:百度知道 编辑:UC知道 时间:2024/06/10 08:12:22
Dim rs_xpa As New ADODB.Recordset
Dim ab_ab As New ADODB.Recordset
Dim ac_ac As New ADODB.Recordset
Dim sqq As String
Dim aql As String
Dim bql As String
Private Sub command1_Click()
sqq = "select * from A表 where id=" & CLng(Text14.Text)
aql = "select * from B表 where sf='" & Text1.Text & "'"
bql = "select * from C表 where sf='" & Text1.Text & "'"
On Error GoTo xi
ab_ab.Open aql, donn, adOpenKeyset, adLockPessimistic
If ab_ab.EOF = False Then
Do While Not ab_ab.EOF
ab_ab.Fields(1) = Text1.Text
ab_ab.Fields(2) = Text2.Text
ab_ab.Fields(3) = Text3.Text
ab_ab.Fields(4) = Text5.Text
ab_ab.Fields(7) = Text6.Text
ab_ab.Fields(8) = Text7.Text
ab_ab.Fields(9) = Text8.Text
ab_ab.Fields(10) = Text9.Text
ab_ab.Update
ab_ab.Close
Loop
End If
ac_ac.Open bql, donn, adOpenKeyset, adLockPessimistic
If ac_a

donn是数据库链接对象,在你的程序中没有发现donn对象的链接,也就是donn对象是关闭的,因此:“对像关闭时,不允许操作”。

对象名称用donn或conn或其他名称都没有问题,关键是要建立链接!!

ab_ab.Open aql, donn, adOpenKeyset, adLockPessimistic
rs_xpa.Open sqq, donn, adOpenKeyset, adLockPessimistic
rs_xpa.Open sqq, donn, adOpenKeyset, adLockPessimistic

是conn 不是 donn 你改下在看看

我的VB 还没那么高,帮不了你!