1,216
社区成员
发帖
与我相关
我的任务
分享
Private Sub Form_Load()
Dim i%, strsql$, strdsn$ ' As String
Dim conn As New ADODB.Connection, rs As New ADODB.Recordset
strdsn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=f:\mysite\db1.mdb"
conn.Open strdsn
strsql = "select * from cd_table"
rs.Open strsql, conn, 1, 3
If Not rs.EOF Then rs.MoveLast
Do While Not rs.BOF
i = i + 1
Debug.Print i, "MoveFirst"
''''''''''''''''''rs.MoveFirst '你永远移动到第一条记录,当然死循环!
rs.MovePrevious
Loop
i = 0
Do While Not rs.EOF
i = i + 1
Debug.Print i, "MoveNext"
rs.MoveNext
Loop
rs.Close: Set rs = Nothing
conn.Close: Set conn = Nothing
End Sub
Do While Not rs.BOF 'BOF的表示移到了第一条的前面
rs.MoveFirst '移到第一条,这么可能到达BOF
Loop '整个循环属于无用代码,可删除之