GetRows

The GetRows method returns a two-dimensional array of properties.

Applies To

All Table objects

Syntax

objAppointmentsTable.GetRows (maximumRows, Arg1, …, ArgN)

Parameters

maximumRows

Specifies the maximum number of rows to retrieve. The maximum is 100.

Arg1, …, ArgN

Specifies the name or identifier of each property whose value is to be returned.

Returns

Variant array

Remarks

Each row in the two-dimensional array that is returned corresponds to an item. Each column in the array corresponds to the specified name or property identifier. Tables and multivalued properties return Null as their property information.

Note The array returned must be created using an Array statement. Using a statically declared array of variants will not work.

The following sample code retrieves three properties from the first 10 rows in the table:

Dim arr As Variant
arr Data = Array (9,2)
arr Data = objAppts.GetRows (10, "Start", "End", "Text")

See Also

GetProperties