一个ado的command问题
请问我用ADO的COMMAND生成一个记录集,用完是否要CLOSE,不会有内存泄漏把?
比如:
dim SQL as string
dim cmd as new adodb.command
dim rs as adodb.recordset
set cmd.activeconnection=mycn
SQL="Select * From 行情 Where code = '" & mycode & "'"
cmd.commandText=SQL
set rs = cmd.execute
....
'要不要 rs.close ?