2 recordsets at once?

Results 1 to 3 of 3

Thread: 2 recordsets at once?

  1. #1
    the other steve Guest

    Default 2 recordsets at once?

    As an add-on to my question on data providers, I could simply open a second recordset. What are the relevant issues? Should I close the first recordset and the first connection and create new objects, or close the recordset and use the existing connection?<BR><BR>This stuff is bit out of my league.

  2. #2
    Join Date
    Dec 1969

    Default What I do is...

    I just open another recordset, and call it rs2. Sometimes in a recordset loop, I need to to open another recordset, so closing the first recordset would not be an option.<BR><BR>Also, Today is June 8th 2001

  3. #3
    Join Date
    Dec 1969

    Default RE: 2 recordsets at once?

    use the same connection, more efficient tha re-establishing it.

Posting Permissions

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