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.

 

[Norie]

GetRows has an argument that lets you specify the field/fields you want to return.

Why not use that?

 

[AlexanderBB]

What is it ? F1 no longer gives me Help, but some annoying online thing (since 2007). Think I'll have to install Office 2003 on the laptop to get it back.

 

[Norie]

Off the top of my head there are 3 arguments for GetRows - rows, start and fields.

The first two determine the no of rows to return and which row to start from.

Fields specifies the, well fields to return, and can be either a single value for a single field or an array for multiple fields.

 

[AlexanderBB]

Norie, I can't find anything like that for Getrows. Only one argument - number of rows.

 

[Norie]

Have a look here.

 

[xenou]

You're in a database - why use filter on an array? Use "WHERE" with a query!

 

[Norie]

xenou

Good point, didn't actually realise this was in th Access section so assumed the OP was working in some other application.

 

[xenou]

Another good option is to grab the data in a recordset, which also has filter functions.

As far as transforming 2d arrays to 1d arrays, I think the best (and only) method I know of is to create a new array and populate it. This sounds like a lot of work but in fact it only takes one pass so it's very quick even with hundreds of thousands of records. You can redimension some arrays but I think the arrays returned by getRows aren't good for that - you can only remove the last dimension which is probably the one with all your data in it!

 

[Norie]

xenou

If this thread was in the Excel section, which is where I originally thought it was, I would be pointing the OP towards Application.Transpose.