Link to home
Start Free TrialLog in
Avatar of countyworker
countyworker

asked on

question about do while loop?

What's the correct coding when you have a access table you want to loop thru each record to do processing and then after it has processed the last record exits the loop
for example pseudo code:

bring table to workspace
go to first record
do while not end of table
 processing stuff here for each record-queries and etc.
 move to next record coding here if needed
loop  


thanks
ASKER CERTIFIED SOLUTION
Avatar of rdrunner
rdrunner

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rdrunner
rdrunner

Didnt know it was unsupported in .NET ;) thanx for the info... Should slowly start to get rid of it then...


*mental note taken...*
You can use of course the do while ... loop function. BUT this loop cost a lot of time. The fastest way to go trough each record is the FOR ... to ... Step ... Next function and a record.movenext.
countyworker:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Experts: Post your closing recommendations!  Who deserves points here?
Avatar of DanRollins
Moderator, my recommended disposition is:

    Split points between: rdrunner and Arthur_Wood

DanRollins -- EE database cleanup volunteer