Deleting Objects

[Daniel Kanev]

Hi all, I am thinking of how objects are deleted in Visual Basic 6. I am now using ADO for DB operations and I am not sure if my program clears objects correctly. I use the following code for creating a recordset --------START------------ Dim RecSet as New ADODB.Recordset 'Execute query here RecSet.Close -------END---------------- That's it. I do not know how to proceed further with releasing the object. In Visual C++ I just call the Release Method of the Recordset pointer and everything is fine. Does Visual Basic automatically clear the object for me? Thank you!

[Naji El Kotob]

Hi, The last step could be: RecSet = Nothing Hope this helps :)

NajiCo http://www.InsideVB.NET[^] It's nice 2b important, but it's more important 2b nice...

[Tom Deketelaere]

when coding in vb6 I always use the following to make sure all objects are cleared dim recset as new adodb.recordset ... recset.close recset=nothing

[Vimalsoft Pty Ltd]

Yes man it will help, they are right, set everything to nothing

Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com

[Daniel Kanev]

Thank you guys, I will try it :)