can i give many

Results 1 to 4 of 4

Thread: can i give many

  1. #1
    rs open and looping Guest

    Default can i give many

    1)Once I do a can i give the same rs many SQL strings?<BR>2) Do i do have to give them different names like string1, string2 ?<BR>3)What about performance, is it better to do, then rs.close, then again? <BR>4)Is it better to do recordset loop and but values into array , then process data or process while in the recordset loop?

  2. #2
    Join Date
    Dec 1969

    Default RE: can i give many

    Once you&#039ve opened a recordset you have to close it before you can re-open it with a different query.<BR><BR>Don&#039t loop through a recordset to put the values in an array - use recordset.GetRows() which returns an array and is very fast.<BR><BR>Dunc

  3. #3
    how do I use this array? Guest

    Default RE: can i give many

    how do I use this array?<BR>Is it GetRows(i) or something?

  4. #4
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: can i give many

    Well i dont know if this has anything to so with the price of a can of beans but you can have multiple quries with the same record set and navigate them with the rec.NextRecordset same name but diff recordset

Posting Permissions

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