Unbounded arrays

Results 1 to 2 of 2

Thread: Unbounded arrays

  1. #1
    Join Date
    Dec 1969

    Default Unbounded arrays

    Is it possible to create an unbounded array. For example, if I need an array to hold records from a table, but I don&#039;t know exactly how many records I will need.<BR><BR>Thank you and God bless you.<BR>Mike

  2. #2
    Join Date
    Dec 1969

    Default RE: Unbounded arrays

    Well, if you&#039;re using .GetRows, you just want a VARIANT<BR><BR>Dim myArray<BR><BR>myArray = rs.GetRows()<BR><BR>If you&#039;re manually building it for whatever reason, you do<BR><BR>Dim myArray() &#039;blank<BR>ReDim myArray(20) &#039; and you can redim it as needed<BR><BR>ReDim Preserve myArray(40)<BR><BR>Check out the keywords in the help manuals...

Posting Permissions

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