array use

[Mike D]

I am trying to populate an array of an uknown deminsion. I am getting a
subscript error. Here is the code

Dim x, arRE_SEQUENCE_NUMBER
x = 0
If Not RS.Eof then
Do while Not RS.Eof

arRE_SEQUENCE_NUMBER(x) = RS("RE_SEQUENCE_NUMBER")
x = x + 1
RS.MoveNext
Loop
End If

What am I missing?

Mike

 

[Jeff Dillon]

You need to ReDim your array

Jeff

 

[Dave Anderson]

I am trying to populate an array of an uknown deminsion. I am getting
a subscript error. Here is the code

Dim x, arRE_SEQUENCE_NUMBER
x = 0
If Not RS.Eof then
Do while Not RS.Eof

arRE_SEQUENCE_NUMBER(x) = RS("RE_SEQUENCE_NUMBER")
x = x + 1
RS.MoveNext
Loop
End If

What am I missing?

RS.GetRows(), for one thing.


--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

 

[dlbjr]

Mike,

Do you mind explaining exactly what you are trying to accomplish?

You may want to use a dictionary object or a client side recordset to manipulate the needed data.


'dlbjr
'Pleading sagacious indoctrination!