n-dimensional arrays

Results 1 to 2 of 2

Thread: n-dimensional arrays

  1. #1
    Mike M. Guest

    Default n-dimensional arrays

    How do I load data into an array for instanca like this:<BR>+---------------+-----------------------+-----------------+<BR>&#124 Name &#124 Phonenumber &#124 Location &#124<BR>+---------------+-----------------------+-----------------+<BR><BR>in a do while loop (reading a recordset).

  2. #2
    Join Date
    Dec 1969

    Default RE: n-dimensional arrays

    You will need an array and a counter.<BR><BR>Try...<BR><BR>Dim arrItems(), i<BR><BR>If Not RS.EoF Then<BR> i = 0<BR> Redim arrItems(RS.RecordCount)<BR> Do While Not RS.EoF<BR> arrItems(i) = RS("Field_Name")<BR> i = i + 1<BR> RS.MoveNext<BR> Loop<BR>End If<BR><BR>Jonathan<BR>jswartz@sentiat.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts