Arrays 1

[leonepaolo]

Hi!

I know it's important to close recordsets and connections and set them to nothing when we're done with them.

Is there a need to erase arrays as well?

Thanks in advance,
Paolo

 

[snyperx3]

Once you leave their scope they are abandoned anyway.

So if you create an array within a sub routine, once you exit the subroutine they are free for anything else to inhabit. If they are global variables, then they are free once you exit the application.

So on...

So i would say. Only if you are defining massive arrays with a global scope then it would be a good idea to erase them.

-Pete

 

[leonepaolo]

Makes sense.
Thanks Pete!

 

[Zion7]

yes Pete, but connections and recordsets, should be
closed & set to nothing. I believe Access attempts to
"Nothing" them, at the end of a procedure, but
may fail.(something like that)
LEAVING THEM OPEN, CAN SLOW DOWN YOUR APP.

 

[snyperx3]

Right Zion...but he already said he knew that...so i didnt address it.

-Pete

 

[Zion7]

...and so he did???
sorry!