Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append From Problem
Message
 
To
09/05/2001 16:25:24
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00505522
Message ID:
00505529
Views:
17
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform