>>>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.