jamescol
07-11-2004, 08:07 PM
Say I start out with any array of unknown size:
[vCode]
Option Base 1
Dim myArray() as Variant
[/Code]
During the procedure, I query a table for the number of rows it contains. Now I need to allocate enough space in the array to hold 1 element for each row. How do I properly accomplish this task?
Next, I hit another table, and need to allocate more space in the array for its rows, while maintaining the data the array already contains? How do I do that?
Thanks,
James
[vCode]
Option Base 1
Dim myArray() as Variant
[/Code]
During the procedure, I query a table for the number of rows it contains. Now I need to allocate enough space in the array to hold 1 element for each row. How do I properly accomplish this task?
Next, I hit another table, and need to allocate more space in the array for its rows, while maintaining the data the array already contains? How do I do that?
Thanks,
James