|
-
Oct 11th, 2000, 02:03 PM
#1
Thread Starter
New Member
Using VB, what is the best way to cycle through a recordset?
for x = 1 to rs.recordcount
next x
OR
while not rs.eof
wend
I've heard that .recordcount can be inconsistent at times; however, I don't know if that is true or not. It would seem that .recordcount would be more efficient than .eof because you don't have to check and see if the recordset is "end of file" yet.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|