Agnes,
I don't think you can solve this in VFP without Numbers table. In SQL Server you can use recursive CTE to create Numbers table.
BTW, Boris, I remember you created some very smart algorithm for 1+2^n records, but I'm afraid I didn't archive that thread - do you remember it?
May be we can create Numbers table in VFP using your idea and a few UNION statements.
>Hi Sergey,
>
>Be patient we me. Maybe I didn't see the solution
>
>My problem in your words
>
>How can I create (if possible) a cursor with the sequential numbers up to MAX(iChair) temporarly within a SELECT SQL and without an extra created cursor?
>
>Your first example simply creates 2*Reccount() records, I have expressed the problems. The second example runs on an extra cursor this is not what I'm looking for.
>
>So what do I miss?
>
If it's not broken, fix it until it is.
My Blog