* * HELP & MANUAL PREMIUM PACK 4 DEMO VERSION * *
This documentation was styled with a demo skin from the Premium Pack 4 add-on for Help & Manual. The contents of the skin are encrypted and not configurable. You can only publish HM projects with this skin. You cannot edit it or change it.
This version is copyright and may only be used for local testing purposes. It may not be distributed.
Please purchase the full version of the Premium Pack to get the configurable skins and remove this notice. The package will also include the Toolbox configuration utility for Premium Pack skins.
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
