.dataSet()

Previous Next

Gets information about a specific data set in a row set. The subdivision into data sets of a row set depends on the value of the data source's "Maximum number of records" property. You can get this value by calling .dataSetIndicator().

Returns an object with static information about this data set. The data set must have been queried already and must exist prior to calling this function, or else the result value is 'undefined'. Whether or not a data set is queried depends on the value of the data source's "Automatically query next data sets" property.

Syntax

.dataSet( data-set )

 

data-set  :=  { current | first | last | index }

The required data-set is one of the following:

•One of the literal values listed and explained in the table below, or

•An index value that is an integer pointing at a specific data set. The index is 0-based: the first data set has index 0, not 1.

Value

Meaning

current

The data set that is currently selected

first

The first data set in the row set

last

The last data set in the row set

Output values

The returned object contains the following fields:

Value

Meaning

index

The data set index value of this data set. The index is 0-based: the first item has index 0, not 1.

start

The index value, relative to the row set, of the first record in the data set.

end

The index value, relative to the row set, of the last record in the data set.

isFirst

A boolean stating whether this is the first data set relative to the row set.

isLast

A boolean stating whether this is the last data set relative to the row set.

isEmpty

A boolean stating whether this data set is empty (= contains no records).

rowCount

An integer indicating the total number of records contained by the row set (including inserted/deleted records).

rowsQueried

An integer indicating the number of records in this data set that have been queried from the server.

 

Example

var dataSetInfo = rowSet.dataSet('current');

if (dataSetInfo.rowCount > 10) {

 var rows = rowSet.rows(dataSetInfo.start, dataSetInfo.start+10);

 …

}