You need to make sure you USE OTHERTABLE IN 0 or
SELECT 0
USE OTHERTABLE
so your cursor does not get closed. Then if you change to SCAN...ENDSCAN, you will not have to remember to SELECT PROCESSTHIS and you don't need the SKIP either.
>Hi LiaM:
>
>Thank you for your response.
>
>> What is in the "Do some more stuff...." part of the code?
>
>I gues the problem might be here, since in this part I USE a few tables exclusively and zap them - which might be why I lose the cursor.
>>
>>Incidentally, instead of Do While !Eof() ... EndDo, why not use Scan ... EndScan - much cleaner.
>>
>
>I'll give this a shot.
>
>Thanks.
Mark McCasland
Midlothian, TX USA