recordset question

Results 1 to 2 of 2

Thread: recordset question

  1. #1
    Join Date
    Dec 1969

    Default recordset question

    Should I close a recordset connection before assigning another query result to the same recordset object? For example:<BR><BR>Set oRS = oCon.Execute(sql,,1)<BR>.......<BR>sql = "....."<BR>oRS.close &#060;--- necessary???<BR>Set oRS = oCon.Execute(sql,,1)<BR><BR>Is the oRS.close statement needed to prevent a memory leak?<BR><BR>Thanks,<BR>John<BR><BR>

  2. #2
    SPG Guest

    Default RE: recordset question

    It is good form to explicitly close your record set before reassigning it. Regardless of any tangible benefit to you now (and it should avoid memory seepage, if not a real hole), it will assure the people who will eventually tend to your code you that you actually *meant* to reassign your record set...<BR><BR>HiH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts