Connection State Property
Record State Property
Recordset State Property
Stream State Property
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