ADODB Object

State

 
Syntax
 
ObjectStateEnum = recordsetobject.State
 
Description
Returns a long value describing if the Recordset object is open, closed, or inthe process of connecting, executing, or retrieving.
 
The State property returns a long value that is the sum of one or more ObjectStateEnum constants. These constants describe if the Recordset object is open, closed, or executing an asynchronous operation.
 
You can call the State property at any time. The default value is adStateClose.
 
 
ObjectStateEnum Constants 
 
Constant
Value
Description
adStateClosed
0
Object is closed
adStateConnecting
2
Object is connecting
adStateExecuting
4
Object is executing
adStateFetching
8
Object is fetching
adStateOpen
1
Object is open
See Also
Command.State, Connection.State, Record.State, Stream.State.
Example
 
If rsChants.State = adStateFetching Then
   MsgBox "Recordset is fetching records", vbOK
End If