ADODB Object

State

 
Syntax
 
long = recordobject.State
 
Description
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
See Also
Command.State, Connection.State, Recordset.State, Stream.State.
Example
 
If objRecord.State = adStateOpen Then
   objRecord.Close
End If