怎样判断一个结果集是处于 open 状态 还是 close 状态！！？

Question

怎样判断一个结果集是处于 open 状态 还是 close 状态！！？

Answer 1

if 结果集.state=adstateopen then 是Open状态，
if 结果集.state=adstateclose then 是close状态。

Answer 2

结果集.state=0   close狀態
结果集.state=1  open狀態

Answer 3

With Rs
        If .State = adStateOpen Then
            .Close
        End If
    End With

Answer 4

if rs.state=adstateopen then rs.close

Answer 5

If (Rs.State And adStateOpen) = adStateOpen Then rsQuery.Close

Answer 6

如果记录集打开了的话，记录集.state=1,否则，记录集.state=0

Answer 7

记录集.state=1,是打开状态，否则，记录集.state=0

Answer 8

if rs.state=adStateOpen then
     rs.close
end if

Answer 9

if rst.state=adStateOpen then
     rst.close
end if

Answer 10

if rs.state then rs.close