Checking number of items in an array 1

[smgeorge99]

How do you check the number of items in an array? More specifically, how can you check to see if an array has nothing in it?

I have a function that returns an array of ID's for a particular table based on certain criteria. It is valid for no rows to be returned. If rows are returned, then I loop through the array and do some processing. If no rows are returned, I just want to move on without looping through the array.

I can't seem to get this to work properly. Any help is greatly appreciated.

 

[jfgambit]

Can you post the code you have now so that we can recommend additions?



"I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?"

 

[LarryDeLaruelle]

Check Help for the UBound and LBound functions.

I think you can use these to determine the size of the array and then take appropriate action.

HTH

Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[Databaseguy]

Dim i as integer
i = ubound(myarray)
If isnull(i)
Nothing there
Else
Has data
End If

 

[ReluctantDataGuy]

If you have a function that returns the array of IDs, then you must be loading the array in that function. And I assume you're creating a recordset to accomplish that.

If that's the case, you can check the value of recordset.recordcount.

If recordset.recordcount = 0 then find a way to pass that value to the code that processes the array.

Possibly you can use the value of the function itself, unless of course you're passing the array itself out as the value from the function. In that case, maybe a module level or global variable will work.

 

[danvlas]

Trap the Subscript Out Of Range error...
If you refer to an element that does not exist, you'll get the nice error number 9.

Good luck



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html