Limited number of DB records returned with 2.02

[Sarah]

This morning I just got my license code for 2.0.2 so I have downloaded 
and tested it. I get the same problems with DB access: the correct 
number of records is reported but after 22, they just repeat. In fact, 
because the move to next record code seems to be broken, it never 
reaches the end so my test stack gets stuck in an infinite loop. Then 
when I command-period to stop it, the cursor doesn't get closed so next 
time I try to connect, I get a "restricted under current license" 
error, which is what happens if you don't close cursors when you have 
finished with them. GRRRR.

However, the same stack, connecting to exactly the same database but 
using Rev 2.0.1 works perfectly.

I built a query using the Database Query Builder in Rev 2.0.2 and it 
works fine. It returns all my records (33 in my test DB) without 
duplicating. So it looks like there is something wrong in the 
revMoveToNextRecord routine.

Workaround:
Instead of starting at record 1 and looping through each record from 
start to finish, I jumped to the last record and looped backwards. This 
worked perfectly! I'll update MySQL tests.rev and upload it to handle 
this error.

Cheers,
Sarah
sarahr at genesearch.com.au
http://www.troz.net/Rev/

P.S. Joel: I tried to respond to your email but my reply bounced. If 
you have another email address for me to try, please email me again.