Array filled from table

[matrixindicator]

Hola,

I have an array nice working.

The elements number of the array can slightly change for next actions. I like to put the elements in a table and fill the array (the elements) with the values of the table.

1. Can this ? How to write this. To get the data with a recordset I suppose.
2. Can this slow down the performance. Now already with an array who feeds a function my query takes a long time to get, calculate the data (1.500.000 records).

Dim RightReeks() As Variant

RightReeks = Array("S A", "SA", "S.A.", "SRL", "S.A", "SA.")
 
    For i = LBound(RightReeks) To UBound(RightReeks)
 
    If (razon Like "* " & RightReeks(i)) Then
        RazonFArray = CStr(RightReeks(i))
    End If
Next i
i = Empty

 

[Ed2020]

Have a look at the GetRows method of the recordset.

Yes, filling an array with a very large recordset could well harm performance. The larger the array (in terms of columns and rows) the more space it will take in memory.

Ed Metcalfe.

Please do not feed the trolls.....

 

[PHV]

I'd use a RightReeks table and a left outer join on the Like condition and thus NO function call ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[matrixindicator]

ok, thanks for the answers.
Good to know that this will slow down performance.
Table itself is not to big (# 70 records).
If I should try this. Has someone a snippet on how to fill the array (is the array taking a variable ?)

I am using a function to get out the legal function out of a string (name of the company). I think I can do this best with a function ?