State - property of the AdoRecordset object
Description:
Detects whether the
AdoRecordset object is open, closed, connecting, executing an asynchronous method or retrieving data.
Values:
0 - (adStateClosed) Object is closed.
1 - (adStateOpen) Object is open.
2 - (adStateConnecting) Object is connecting.
4 - (adStateExecuting) Object is executing an asynchronous method.
8 - (adStateFetching) The records of the object are being retrieved.
Note:
Property access for
read only.
The property can have a combination of values. For example, if an asynchronous method is executing, then this property will have a combined value of
adStateOpen and
adStateExecuting.
Example:
JavaScriptVBScriptSelect and copy to clipboard
var nState = oRs.State;
// Reading from the property
Dim nState
nState = oRs.State
' Reading from the property