Views on recordsets

Results 1 to 2 of 2

Thread: Views on recordsets

  1. #1
    Join Date
    Dec 1969

    Default Views on recordsets

    Is there a performance hit or benefit in not closing a finished recordset before using it again with a new SQL statement. What course of action would you suggest?

  2. #2
    Join Date
    Dec 1969

    Default RE: Views on recordsets

    The problem with not closing a recordset before reusing it is that it will throw an error. You can&#039;t open an already-open recordset!<BR><BR>Or did you mean not setting it to nothing after closing it? That&#039;s obviously a good idea, because you only have the overhead of object creation once.<BR><BR>Dunc

Posting Permissions

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