|
<< Click to Display Table of Contents >> Navigation: ThinBASIC Modules > ADODB > ADODB Module Classes > ADODB_Recordset > ADODB_Recordset Properties > <ADODB_Recordset>.State |
Description
Returns a value that describes if the object is open, closed, connecting, executing or retrieving data.
Syntax
n = <ADODB_Recordset>.State
Returns
Number: Connection State.
Possible values:
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 |
Parameters
Name |
Type |
Optional |
Meaning |
Remarks
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
Restrictions
See also
Examples