楼上, 还在吗?这个程序的主要目的时进行图的宽度优先遍历。在node_a表中,存放节点的信息,在aaa中存放关系的信息 Dim Rs As ADODB.Recordset Dim tRs As ADODB.RecordsetSet tRs = New ADODB.Recordset Set Rs = New ADODB.RecordsetSTemp = "select * from node_a" Rs.Open STemp, CurrentProject.Connection, adOpenKeyset, adLockOptimistic Rs.MoveFirst i = 0 For j = 1 To Rs.RecordCount 针对node_a中的节点搜索与其相关联的节点放到TEMP中 tTemp = "select * from temp" tRs.Open tTemp, CurrenProject.Connection, adOpenKeyset, adLockOptimistic /当程序运行到此处遇到错误,错误提示为“要求对象”,也就是,CONNECTION对象没有连接 Do While Not tRs.EOF tRs.MoveFirst 针对TEMP中的节点搜索与其相关联的节点也放到TEMP中 Loop End If Rs.MoveNext Next j MsgBox "程序执行完毕"
Dim Rs As ADODB.Recordset
Dim tRs As ADODB.RecordsetSet tRs = New ADODB.Recordset
Set Rs = New ADODB.RecordsetSTemp = "select * from node_a"
Rs.Open STemp, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
Rs.MoveFirst
i = 0
For j = 1 To Rs.RecordCount
针对node_a中的节点搜索与其相关联的节点放到TEMP中
tTemp = "select * from temp"
tRs.Open tTemp, CurrenProject.Connection, adOpenKeyset, adLockOptimistic /当程序运行到此处遇到错误,错误提示为“要求对象”,也就是,CONNECTION对象没有连接
Do While Not tRs.EOF
tRs.MoveFirst
针对TEMP中的节点搜索与其相关联的节点也放到TEMP中
Loop
End If
Rs.MoveNext
Next j
MsgBox "程序执行完毕"