State property
May not be available in early versions of ADO.
The State property returns a value that describes if the object is open,
closed, connecting, executing or retrieving data. The value returns an
ObjectStateEnum value. Default is adStateClosed.
This property can be used with the
Command, Connection, Record,
Recordset, and Stream object.
The State property can have a combination of values. If a statement is executing,
this property will have a combined value of adStateOpen and adStateExecuting.
ObjectStateEnum Values
Specifies whether an object is open or closed, connecting to a data source,
executing a command, or retrieving data.
Constant
Value
Description
adStateClosed
0
The object is closed
adStateOpen
1
The object is open
adStateConnecting
2
The object is connecting
adStateExecuting
4
The object is executing a command
adStateFetching
8
The rows of the object are being retrieved
file: /Techref/language/asp/comp/state.htm,
1KB, , updated: 2003年9月19日 12:56, local time: 2025年9月9日 09:34,
©2025 These pages are served without commercial sponsorship. (No popup ads, etc...).Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Questions?<A HREF="http://techref.massmind.org/techref/language/asp/comp/state.htm"> State property </A>
Did you find what you needed?
Welcome to massmind.org!
Welcome to techref.massmind.org!
.