Skip Headers

Oracle® Objects for OLE Developer's Guide
10g Release 1 (10.1)

Part Number B10118-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

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
Description
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