>>>as it is a vfp table, add a bracket to WHERE into which recno() has to be BETWEEN, and increment bracket borders in a loop
>>
>>Hi Thomas,
>>
>>thanks for the response.
>>
>>Was there not something to not use RECNO() / RECCOUNT() in SELECT SQL? Do you think it's thrustworthy?
>
>Yes, and the rule was "don't use any alias related function when selecting from more than one alias". I've done that hundreds of times, and everything went right when I selected from a single cursor, and gave errors when there were more.

Yes, but, as Thomas points out, COPY TO ARRAY ... NEXT ... seems more easy if it comes to kludges. :)

>>What if next release breaks behaviour. :)
>
>Live in fear...

All the time.