How to determine size and status of an array

[ray306]

I have a array variable that I use to hold the result of database query.

I need to check the array before addressing it .

For instance I can use isArray()to check whether it is indeed an array. If the array is empty it will still

return 1(True) to the function. Normally you would check Array[0] but if the array variable is blank

the function will cause a fatal error ie. subscript out of range.

Any ideas on how to accomplish this?

I need to know its status so I can throw an error before actually attempting to perform operations if it happens to be empty.

Thanks

Ray

[Xenobiologist]

Hi,

size --> check Ubound()

status --> declare it so you are yure it is an array.

So long,

Mega

[ray306]

Hi,

size --> check Ubound()

status --> declare it so you are yure it is an array.

So long,

Mega

Thanks Mega

Knew it was something simple.

BrainfreezeI guess

Thanks

Ray