An enumerated value indicating the rowset’s current mode.

Property of

Rowset

Description

The state property is read-only, indicating which mode the rowset is in, as listed in the following table:

Value

Mode

0

Closed

1

Browse

2

Edit

3

Append

4

Filter

5

Locate

When the rowset’s query is not active, the rowset is Closed.

While the query is active, the rowset is in Browse mode when it’s not in one of the next four modes.

The rowset is in Edit mode after a successful beginEdit( ) (implicit or explicit) and it stays in that mode until the row is saved or abandoned.

After a successful beginAppend( ), it is in Append mode. It stays in that mode until the new row is saved or abandoned.

After a beginFilter( ), it is in Filter mode. It stays in that mode until there is an applyFilter( ) or the Filter mode is abandoned.

After a beginLocate( ), it is in Locate mode. It stays in that mode until there is an applyLocate( ) or the Locate mode is abandoned.