looping through recordset using maybe index for recrods?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

Thank you in advance for your help.

I know I can loop through an ADODB recordset by movenext. Is there a way to
loop through it using some index for the recrods? I am looping through
multiple tables at the same pace. For example, i want to be able to pick the
fourth records from 5 recordset. Thanks a lot.

chun
 
I just use getrows() to convert the recordset to an array. Is this the best
approach? thanks.
 
Look at the help entry for the AbsolutePosition property and see if that
sounds like what you want, but read the warnings to make sure they don't
apply to your situation:
"You should not use the AbsolutePosition property as a surrogate record
number...."

HTH,
 
Back
Top