multiple recordsets

Results 1 to 2 of 2

Thread: multiple recordsets

  1. #1
    Join Date
    Dec 1969

    Default multiple recordsets

    is there a way to retrieve multiple recordsets with one request to the recordset object with access?<BR>as with SQL server:<BR><BR>sSQL = sSQL & ";SELECT * FROM tableName WHERE column = &#039;someStr&#039;"<BR><BR>so this would return two unique recordsets appended together to act as one. i tried this with access and of course it didn&#039;t work. is there a work around to get this technique to work?

  2. #2
    Join Date
    Dec 1969

    Default wrong forum..

    You can use batch recordset:<BR>SQL="SELECT * FROM tableName WHERE column = &#039;"&someStr&"&#039;;"<BR>SQL = SQL & "SELECT * FROM tableName2 WHERE column =&#039;"&someStr&"&#039;"<BR><BR>&#039;do smth with 1st recordset<BR> ...<BR> SQL,conn...<BR>&#039;when you done do not close connection and rs<BR>set rs = rs.nexrecordset<BR>&#039;do smth with 2st recordset<BR><BR><BR>

Posting Permissions

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