Navigation:  ThinBASIC Modules > ADODB > ADODB Module Classes > ADODB_Recordset > ADODB_Recordset Properties >

<ADODB_Recordset>.State

Previous pageReturn to chapter overviewNext page

 

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