looping through recordset using maybe index for recrods?


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
 
Ad

Advertisements

G

Guest

I just use getrows() to convert the recordset to an array. Is this the best
approach? thanks.
 
Ad

Advertisements

G

George Nicholson

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top