ReDim Method (XArrayDB)

XArrayDB Reference> XArrayDB Object Methods> ReDim Method (XArrayDB)

This method is used to set or reset the dimensions of an XArrayDB object while preserving any existing data.

Syntax

XArrayDB.ReDim rowLB, rowUB, columnLB, columnUB

Arguments

rowLB and rowUB are long integers specifying the lower and upper bounds for row indexes.

columnLB and columnUB are long integers specifying the lower and upper bounds for column indexes.

Return Value

None

Remarks

Method applies to XArrayDB object.

Since a newly created XArrayDB object does not have any default dimensions, you must use the ReDim method before you can assign or access array elements.

Example

The following example creates and initializes a two-dimensional XArrayDB object. The first dimension has 100 elements, with indexes starting at 1 and ending at 100. The second dimension has 6 elements, with indexes starting at 0 and ending at 5.

Dim MyArray As New XArrayDB

MyArray.ReDim 1, 100, 0, 5