Paige,
Since your filename/path contains a space, you must put the filename inside " so that VFP knows what the full filename is. The space character isbeing seen by VFP as a break between clauses of the command and it sees:
documents\mydownload files\download.txtAs clauses that should be parts of the APPEND command.
The first works because the short form version of the filename does not contain spaces.
This will work:
Append from "c:\my documents\my download files\download.txt" delimited with character ","
This would also work:
lcFileName = "c:\my documents\my download files\download.txt"
Append from (lcFileName) delimited with character ","
> Append from c:\mydocu~1\mydown~1\download.txt delimited with character ","
>
>But this following command:
>
> APPEND FROM &lcSelected DELIMITED WITH CHARACTER ","
>
>generates the error: "command contains unrecognized phrase/keyword". In Debug the "&lcSelected" displays the appropriate path/file name; but expanded:
>"c:\my documents\my download files\download.txt"
>
>I get the path from: lcSelected = GETFILE("TXT")
>
>I'm working in VFP 5/6.
>
>Is there some syntax rule that I can't use a macro in the Append From command? Suggestions will be appreciated. TIA.
>
>Regards,
>
>Paige