求救!数据集rst不能用rst.MoveFirst,rst.MoveNext,Movelast...
各位大虾,救救我!
下面一段示例代码当运行到 rst.MoveFirst
时就死机,CPU使用率100% ,rst中是有记录的,把 rst.MoveFirst改成movenext,movelast等也一样
如果不用move..,就能运行。
反正rst就是不能移动,为什么啊!!!!大家有没有遇到过这种情况啊
救救我吧!
Private Sub Command1_Click()
Dim mrc As ADODB.Recordset
Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim SQL As String
Set cnn = New ADODB.Connection
cnn.ConnectionTimeout = 5
cnn.Open "filedsn=youyi.dsn;uid=sa;pwd="
Set rst = New ADODB.Recordset
SQL = "select * from vender"
rst.Open Trim$(SQL), cnn, adOpenKeyset, adLockOptimistic
MsgBox "查询到" & rst.RecordCount & "条记录!"
If rst.EOF = False Then
rst.MoveFirst
Do While mrc.EOF = False
MsgBox mrc.Fields(0)
rst.MoveNext
Loop
End If
Set rst = Nothing
Set cnn = Nothing
End Sub