Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help with combining cursors
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00226046
Message ID:
00226062
Views:
28
>I created a cursor with a blank record in it, but I have to loop X times to add X blank records to the cursor, not just one. So I thought I might use a FOR...ENDFOR loop.
>
>And after that I hope to have X blank records in the cursor, but then I have to append actual non-blank records from my table to the cursor that is full of X blank records.
>
>The reason I have to put X number of blank records in front of the actual records is so that when I print laser mailing labels I can start printing at the point where I left off and that way I don't waste laser labels.
>
>How can I do the SELECT... INTO CURSOR to accomplish the above? Thanks for helping.

I don't know a way to specify X blank records in SQL. But here's a way that's a slight improvement, maybe (or maybe not :)

Do the SQL into the cursor. USE DBF() AGAIN to make it RW. Then INSERT or APPEND the X blank records. Then index to get the blanks to the top.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Reply
Map
View

Click here to load this message in the networking platform