Hello George,

I just found that the computer where this code doesn't work has the ANSI off.
When I switch to ON it works. Any ideas why this is happening?

Thank you again.


>Hello George,
>
>I just tried what you told me but it's not working in one computer. When I issue this command "CFILE = DBF()", the file used in the SELECT command is stored instead of the cursor's name. On the other computer, the name of the cursor is stored and when I see what's in CFILE I get "C:\WINDOWS\TEMP\41IB000V.TMP"
>
>What could be causing such thing? Any suggestions?
>
>
>
>>>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,