|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
