>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?
>
Hi Morys,
It sounds like the NOFILTER clause is missing in the first instance. As I mentioned in my previous post, without NOFILTER, the table is being used again and filtered. The second instance sounds fine to me. Don't forget that the cursor file is temporary and will be destroyed when the cursor is closed. VFP automatically generates a random file name that has nothing to do with the alias and stores it in the location with the rest of its temporary files.
George
Ubi caritas et amor, deus ibi est