GetRows to Array

[AlexanderBB]

I have opened a recordset to 2 fields in my table and applied GetRows.

The result is

How could I best get field 1 into a 1 dimensional array and field 2 into another 1 dimensional array ?
The reason is to Filter them and that needs a 1 dimensional array.

 

[AlexanderBB]

>You're in a database - why use filter on an array? Use "WHERE" with a query!
I wanted 2 fields from the table, each copied to their own array.
Afaik Getrows in the only way to get a recordset into an array. But you get an array that's no good and whatever approach results in a bottle neck of some kind.

Here's my 2 to 1 deminsion stuff. maybe it can be improved on ?

Function TwotoOneDimension(a3)
Dim i%, OneD As Variant
ReDim OneD(UBound(a3, 2))
For i = 0 To UBound(a3, 2)
    OneD(i) = a3(0, i)
Next
TwotoOneDimension = OneD
End Function

When I use Getrows in Access, I don't get those extra argument options showing

 

[Norie]

Just because Intellisense doesn't list it doesn't mean it's not there.

What version of ADO are you using anyway?

Also, why do you want 2 separate arrays from the same table?

 

[xenou]

AlexanderBB is probably using the DAO GetRows() method, not the ADO GetRows() method.


This function looks fine to me. Performance should be good, since it's a single pass through the records:

Function TwotoOneDimension(a3)
Dim i%, OneD As Variant
ReDim OneD(UBound(a3, 2))
For i = 0 To UBound(a3, 2)
    OneD(i) = a3(0, i)
Next
TwotoOneDimension = OneD
End Function

>You're in a database - why use filter on an array? Use "WHERE" with a query!
I wanted 2 fields from the table, each copied to their own array.
Afaik Getrows in the only way to get a recordset into an array. But you get an array that's no good and whatever approach results in a bottle neck of some kind.

Note, here I was more imagining not using arrays at all - recordsets can do filtering too. However, arrays are enjoyable to work with for their simplicity and efficiency, so no problem if you find them preferable in this situation.

 

[AlexanderBB]

> Also, why do you want 2 separate arrays from the same table?

Been thinking how best to answer that (without going into a complex and boring design speal...) but I can't !
Yes, I am using the native Getrows from Access 2007.

Thanks for the replies, I think I'm there now, with as good a method as there is

Rgds, ABB