>>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.
>What if next release breaks behaviour. :)
Live in fear...