ADO » Record » State

Version: 2.5

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


If objRecord.State = adStateOpen Then
End If

See Also: