David C. Barber wrote:
> Why is it that after I close an ADO recordset defined locally
> 
>     Dim adoRS as New ADODC.Recordset
> 
> that so many examples insist that I should set it to nothing as well?
> 
>     adoRS.Close
>     Set adoRS = Nothing
>     Exit Sub
> 

Presumably so that the internal memory manager releases the object from 
the heap.

 > Isn't it sufficient to have it go out of scope when I exit the 
subroutine?

Probably not, but maybe. Since the internals of memory management in VB 
are not published, it's hard to know when objects are discarded from the 
heap.

If it were C++, then an object instantiated with New would need to be 
deleted by the programmer. Given that VB is not written in VB, one 
assumes that the same rule applies.

Ian
---
þ RIMEGate(tm)/RGXPost V1.14 at BBSWORLD * Info{at}bbsworld.com

---
 * RIMEGate(tm)V10.2áÿ* RelayNet(tm) NNTP Gateway * MoonDog BBS
 * RgateImp.MoonDog.BBS at 12/2/04 5:51:56 AM