PROPERTY:  Command::State

long = commandobject.State
 
The State property returns a long value that is the sum of one or more ObjectStateEnum constants. These constants describe if the Command object is open, closed, connecting, executing, or fetching. The default value is adStateClosed.

You can call the State property at any time.
 
ObjectStateEnum Constants
 
Constant Value Description
adStateClosed 0 Object is closed
adStateOpen 1 Object is open
adStateConnecting 2 Object is connecting
adStateExecuting 4 Object is executing
adStateFetching 8 Object is fetching

 
Code (VBScript):
If (objCommand.State = adStateClosed) Then
   Response.Write "Command object is closed"
End If

Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information