Populate an array using GetRows

[jeffreyccs]

Hi

I would like to populate an arrray using the GetRows method, however I would like to use Base 1 and using GetRows defaults to Base 0 even hough Option Base 1 is set.

Is this possible or should I use a different method to populate the array.

Any advice would be appreciated

Regards

Jeff

 

[tvanstiphout]

What is the bigger picture of what you're trying to do? Maybe we can suggest alternatives.
Not that it's difficult to do the mental leap from 1 to 0

 

[jeffreyccs]

Thanks for your feedback

I have populated the array by looping through a recordset.

Regards

Jeff

 

[Pat Hartman]

A recordset IS an array so there is no need to read one array into a different array. Just use the recordset directly. One situation where you might use an array (you could also use a recordset) is if you need to generate a mortgage amortization schedule. You start with three variables. The loan amount, the term, and the number of payments per year. Then using a loop, you fill a multidimensional array with the year, month, principal, interest, LoanBalance.

 

[jeffreyccs]

Thanks for your input

Regards