Good Day Experts!
I am having trouble with this seeminlgy simple task. I am converting a VB6 program that had a Do/Loop that ran a query each time through. If certain data was encountered the loop is exitied. Then the Do/Loop Reordset is reset back to the beginning with .MoveFirst.
So, In my conversion I have:
DataTable that I am iterating through using a For/Next loop. In it I run a query which may contain data that requires exiting from the loop.
After I exit from the loop, I need to get back to the first row of the DataTable so I can iterate through it again.
How can I achieve this?