Clearing an array

[emblewembl]

Hi,

I need to clear an array and am not sure how to do this. Can anyone tell me or point me in the right direction?

Thanks!

i love chocolate

 

[JohnYingling]

Redim ary(-1)
OR
Erase ary
OR
ary = Nothing

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing Control

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[emblewembl]

Hi John, Thanks for your reply. I tried using myarray = Nothing to reset it but it doesn't seem to be working for me. I'll explain exactly what I'm doing so you understand what I mean.

1. BuildArray() 'populates array with item one details
2. WriteArray(1) 'writes contents to screen
3. ResetArray() 'sets array = nothing
4. WriteArray(2) 'writes array to confirm it is empty

But I get this error on the second time it tries to write the array (which should now be empty). The error is:

System.NullReferenceException: Object reference not set to an instance of an object.

How can I achieve clearing the array without this happening?



i love chocolate

 

[bradlkm]

Since the array is now "nothing" then you can not try to access the array without getting an error.

Simply check to see if it is nothing:

if myArray is nothing then
'Array has been cleared
else
'Array has not been cleard
end if

HTH!

Kevin B.
.Net Programmer

 

[JohnYingling]

If you MUST have an "empty" aray, then use
Redim ary(-1) ' Yes...-1 Ubound gives ary.Length=0

Dim ary() as string and Dim ary(-1) as string are not the same. The first is an object with value NOTHING while the second is an array with Length = 0 (Ubound=-1)

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing Control

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript