How to iterate through results of SQL Query

[David Wessell]

Hi,

Easy question here, but I'm not finding any examples..

If I've just placed a SQL query, how can I iterate through the results
using VBA?

rs.Open "SELECT * FROM generic table", _
dbMain, adOpenKeyset, adLockPessimistic

 

[Guest]

David,

try something like this:

While Not rs.EOF
'do something with the current record. i.e.
Debug.Print rs(0)
'move to the next one
rs.MoveNext
Wend

 

[David Wessell]

Vergel,

Thanks a ton.. That's perfect!

 

[murali.tammineni]

David,

try something like this:

While Not rs.EOF
'do something with the current record. i.e.
Debug.Print rs(0)
'move to the next one
rs.MoveNext
Wend

--
Hope that helps.

Vergel Adriano








- Show quoted text -

Hey Buddy,
THaks a lot. It helped me just now