ADO » Recordset » State
- Syntax:
- ObjectStateEnum = recordsetobject.State
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 adStateClosed.
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 |
Examples
Code:
If rsGuruChants.State = adStateFetching Then
MsgBox "Recordset is fetching records", vbOK
End If
See Also:
