GetRows Method

Applies To

OraDynaset

Description

Retrieves multiple records of a Dynaset object into variant safearray .

Usage

Array =OraDynaset.GetRows( num_rows, start, fields )

Arguments

numrows [optional]	An integer representing the number of records to retrieve. Default value is total number of rows in the dynaset.
start [optional]	An Integer representing the starting position of the dynaset from which the GetRows operation should begin. Default value is current position of the dynaset.
fields [optional]	A Variant representing a single field name or fields position or an array of field names or array of field position numbers. GetRows returns only the data in these fields.

Remarks

Use the GetRows method to copy records from a Dynaset into a two-dimensional array. The first subscript identifies the field and the second identifies the row number. The Array variable is automatically dimensioned to the correct size when the GetRows method returns the data.

Calling GetRows method does not change the current row position of the dynaset object.

Example