>This is my code:
>SELECT * FROM accounts INTO CURSOR TheCursor
>SELECT TheFile
>APPEND FROM TheCursor
>
>I get an error message, file "THECURSOR" doesn't exist!
>
>Question!
>How do I append records FROM a cursor?
>
>Thank you in advance.

Hi Morys,

First, I'd add the NOFILTER clause to make sure I wasn't getting a filtered result set from the query. Second, get the actual filename of the cursor using the DBF() function for the filename. Basically, it's like

* Assuming TheCursor is selected
lcfilename = DBF()
SELECT TheFile
APPEND FROM (lcfilename)

hth,