By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,326 Members | 2,726 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,326 IT Pros & Developers. It's quick & easy.

Recordsets

P: 93
Hi as i have been working i have noticed things in vb which i think i may need clarification.

What is the difference between recordset.Close and Recordset = nothing
it is used bot times in many of the forms, but some times only uses nothing. is there a way to use this.

Like for a global recordset you would use .close while a private recordset in a form would just use = nothing

thanks in advance if anyone can help
Apr 24 '07 #1
Share this Question
Share on Google+
2 Replies


100+
P: 375
Hi as i have been working i have noticed things in vb which i think i may need clarification.

What is the difference between recordset.Close and Recordset = nothing
it is used bot times in many of the forms, but some times only uses nothing. is there a way to use this.

Like for a global recordset you would use .close while a private recordset in a form would just use = nothing

thanks in advance if anyone can help

I was taught that when you are finished with the recordset you close it.
recordset.Close()
whereas if you want to reuse the recordset you can open it again but otherwise release the object variable from memory by the statement
Set recordset = Nothing
Apr 24 '07 #2

100+
P: 149
Hi as i have been working i have noticed things in vb which i think i may need clarification.

What is the difference between recordset.Close and Recordset = nothing
it is used bot times in many of the forms, but some times only uses nothing. is there a way to use this.

Like for a global recordset you would use .close while a private recordset in a form would just use = nothing

thanks in advance if anyone can help
recordset.Close will close the recordset but it can be opened once again later in the program to be used. Where as Recordset = nothing refers to releasing the memory that was used by the recordset.

-ansuman sahu
Apr 24 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.