>I am just curious where did you find such command, I don't see it in the help.
>
>>>I have a remote view defined in my database container. How do I copy the data from my view to a table? I was trying to APPEND FROM but is not working. Thank you in advance.
>>
>>You can
>>
>>APPEND FROM DBF("MyRemoteView")
Morys,
DBF() is in the help file, it returns the physical file name for a cursor (that is a view, cursor, table that is currently open).
When you open a view named MyView then MyView is the alias name for the work area the views resides in. It is not the name of the physical file that holds the data, that file is named something like C:\Temp\1123428.tmp.
The APPPEND FROM connad requires a physical file name and so you need to use the DBF() function to get the physical file name for the view.