>I am having a problem doing an APPEND FROM from an SQL cursor. The code looks like this:
>
>SELECT [blah blah blah] INTO CURSOR MyCursor2 NOFILTER
>SELECT MyCursor1 && this is an SQL cursor, not a table
>APPEND FROM DBF("MyCursor2")
>
>This failed with the message "File '[fullpath file name].tmp' does not exist".
>This happens even though I looked in the DataSession window and found the cursor (MyCursor2).
>
>This code also fails: APPEND FROM DBF(ALIAS("MyCursor2"))
>
>However, very strangely, if I execute the code "Select MyCursor2", it works!
>Any ideas?
>
>BTW, the SQL Select that created MyCursor2 includes a GROUP BY clause.
>
>I have a workaround: I select the cursor MyCursor2, scan through it, and copy it row by row into MyCursor1. This works, but I would like to use the APPEND FROM if possible.
>
>It's very perplexing. Thanks for any help.

I have no idea if this will help (and you may have tried it anyway) but, just before you try the APPEND command check

DBF("MyCursor1")
FILE(DBF("MyCursor1"))

DBF("MyCursor2")
FILE(DBF("MyCursor2"))

I don't know what it would mean, but it might be interesting if neither DBF() command gave the same file name as in the error message.

and, since nothing else seems to have worked, how about trying a FLUSH just before doing the APPEND