>>>>Does it have to be SCAN/ENDSCAN?
>>>
>>>I can use DO WHILE instead, but I always prefer SCAN.
>>
>>Thtat's not what I had in mind. Can it be done using SQL commands?
>
>Ok, finally I've realized, that I can not use scan/endscan and I have to switch to
>
>for i=1 to reccount() + 1
>
>next
>
>Thanks.

Alowing that you missed 'skip' in a hurry, hv to ask ;
What is the diff ? It comes down to the same any way you turn it.
Weather u r doing for/skip/next or dowhile/skip/enddo or scan/endscan,
you are basically going arround the same bush.

If you need to go trough records one by one, then by all means
you should use scan/endscan which is designed for that.
It spares you of ugly eof/bof traps and does skip for you. What can you possibly gain by doing for/skip/next unless, that 'I' counter is your goal :))