Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append From Fixed Width file
Message
From
20/06/1997 17:55:43
 
 
To
20/06/1997 14:40:35
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00037175
Message ID:
00037236
Views:
38
>>>and then VFP will divide text file according to table (cursor) structure, therefore you should have:
>>>1. Exact length corresponding between table and text file.
>>
>>I was afraid that's what your response was going to be!
>
>That's not a serius obstacle:
>1. Create 'import cursor' with the exact structure.
>2. Append to this cursor.
>3. Append to real table from cursor using APPEND FROM ... FIELDS ... and/or some kind of SELECT-SQL commands.

And to throw my two cents in, it's not really that painful - we do that all the time. It's just like specifying a map of the original fixed length file.

For that matter, depending on your needs, you can either define a permanent table in advance, ZAPping is before the APPEND, or create a cursor on the fly.
David M. Stowell
Ravenslake Consulting
Chicago, Illinois

e-mail: davidstowell@ravenslakeconsulting.com
Previous
Reply
Map
View

Click here to load this message in the networking platform