Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
APPEND FROM missing a column
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
APPEND FROM missing a column
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows Server 2012 R2
Network:
Windows Server 2012
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01648241
Message ID:
01648241
Vues:
47
Hi All,
I am importing a file and noticed that it sometimes mises a column. I have a cursor with 12 text columns and am appending in a csv file with various values. If I use
APPEND FROM &mFileName TYPE csv
Then I miss the top row, which I need. So I've bene using this, but it gave a weird issue today. If there is any column, field, that does not have data at all then it is skipped, so field 9 becomes field 8. If even 1 field 9 has data then it is fine, but for me field 9 will be blank a lot and I rely on a calculation based on any values in field 8.
APPEND FROM &mFileName delimited with ,
Any idea how to solve this?
~M
Go raibh maith agat

~M
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform