Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append From Problem
Message
 
 
À
09/05/2001 16:25:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00505522
Message ID:
00505596
Vues:
19
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform