|
|
|
|
|
| | |
| |
Active Server Pages ASP programs help tutorial tutorials routine routines jobs listserve mailinglist bulletin board bulletin boards programming snippet snippets CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Which is the better way? |
|
From: |
NILESH |
|
Date: |
4/30/1999 11:47:55 AM |
|
IP: |
196.1.109.11 |
I have a code which looks like :
<%
Set objConn = CreateObject("ADODB.Connection")
objConn.Open strDSN
Set objRS = objConn.Execute(" ....
.
.
.
objConn.Close
Set objConn = Nothing
%
So my question is : Is it necessary to explicitly close and then destroy
the recordset object as follows ?
<%
objRS.Close
Set objRS = Nothing
%
I've read somewhere that if recordset is using some connection object, then after
closing and destroying the connection will release recordset object automatically. I am not sure about what I have read ....So I want to know if it is true?
Thank u all
☺NRK
|
Follow Up - Re: Which is the better way? - sreeram.b 6/20/1999 2:41:56 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
