ADO: ActiveX Data Objects

Name

Recordset.GetRows Method — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

Set record_array = recordset.GetRows(Rows, Start, Fields)

The GetRows method of the Recordset object returns multiple records from an open Recordset object in the form of an array.

Arguments

Rows (Long)

Optional. Indicates the number of records to retrieve. The default value for this argument is adGetRowsRest (value of -1).

Start (String or Variant)

Optional. Evaluates to a bookmark where the GetRows method should begin.

Fields (Variant)

Optional. Specifies which fields should be returned for each record by the GetRows method. Represents a single field name, a single field-ordinal number, an array of field names, or an array of field-ordinal numbers.

Returns

Variant (two-dimensional array)

Description

The GetRows method of the Recordset object returns multiple records from the same Recordset object into a two-dimensional array. The records are returned in the form of a Variant array that is automatically dimensioned by ADO. The first subscript is the field; the second is the record number. The data returned is read-only.

You can specify the number of records to be returned through the first argument. If this value is larger than the number of records, only the remaining records are returned.

If the selected Recordset object supports bookmarks, you can specify the starting location by passing the value of the record’s Bookmark property.

After the call to GetRows, the record pointer is set to the next unread record, unless ...