Destructing a variable in VB

[RichS]

How do I remove a global variable from memory in visual basic. I want to redim it when I need it and remove it when I no longer need it.

Rich

 

[JohnYingling]

Dim globalArray() as string
Redim globalarray(10000)
.....
Redim globalarray(0) ' reduce to 1 Item
OR
Erase globalarrray

http://WWW.VBCompare.Com

 

[RichS]

Thanks for the response John. The Erase doesn't work on a long or an integer. Is there a way to erase these types?

 

[TimLarkin]

To my knowledge, you can't destroy or create a global variable in proccess(that is, by clicking on a button or something). However, my question to you is, Why would you want to? Tim

Remember the KISS principle:
Keep It Simple, Stupid!

 

[JohnYingling]

Then just Redim globalarray(0) to save storage which I assume is what you want.

http://WWW.VBCompare.Com

 

[RichS]

- Tim
It is a variable that will be used infrequently and it is a matter of style that I don't like to leave useless variables hanging around out there with infinite life. I know it's not critical and with the amount of resources used it's immaterial. Just trying to perfect my knowledge of VB.

- John
Thanks for the suggestion. However, I will probably just not worry about the space used.

 

[TimLarkin]

Rich:
Sounds to me like these seldom used variables should not be declared as Public(Global) in the first place. It is good programming practice to AVOID using Public variables.

Try declaring a seldom used variable as a LOCAL variable in a routine, and if you need to, pass that variable to the routine that needs it.

Sometimes you just need that Public variable in place, even though your program might never use it during a run.

As a quick example of where you might need one:

Public booCancel As Boolean

Private Sub cmdCancel_Click()
booCancel = True
End Sub

Private Sub DoWork()
Do While Not booCancel
DoEvents
'do work
Loop
End Sub

Tim

Remember the KISS principle:
Keep It Simple, Stupid!