ADO » Record » State
Version: 2.5
- Syntax:
- long = recordobject.State
Returns a long value describing if the Record object is open or closed.
The State property returns a long value that is the sum of one or more ObjectStateEnum constants.
These constants describe if the Record object is open, closed, or executing.
The adStateConnecting and adStateFetching constants are not used.
The default value is adStateClosed.
You can call the State property at any time.
ObjectStateEnum Constants
| Constant | Value | Description |
|---|---|---|
| adStateClosed | 0 | Object is closed |
| adStateConnecting | Not used | |
| adStateExecuting | 4 | Object is executing |
| adStateFetching | Not used | |
| adStateOpen | 1 | Object is open |
Examples
Code:
If objRecord.State = adStateOpen Then
objRecord.Close
End If
See Also:
