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:
00505596
Views:
18
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\my
download
files\download.txt

As 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
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform