>Hi All,
>
>The following command works fine:
>
> 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
Build the whole thing as one macro
lcCommand = 'APPEND FROM '+&lcSelected+' DELIMITED WITH CHARACTER ","'
&lcCommand
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California