Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
APPEND FROM missing a column
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
APPEND FROM missing a column
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows Server 2012 R2
Network:
Windows Server 2012
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01648241
Message ID:
01648241
Views:
48
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
Next
Reply
Map
View

Click here to load this message in the networking platform