How can I handle a dynamic array that contains no records at all.
(i.e has not been redimensioned)

That is, an array defined as

VB Code:
  1. Dim str_Array() as String

is supposed to get populated with data from a database. Sometimes there are no data.. and thus.. no redimensioning of the array will take place.

The problem is that

VB Code:
  1. Ubound(str_Array)

returns a subscript-out-of-range-message. I could rewrite the code so that this situation does not occur, but that means more work for me.

Suggestions?