Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append From Fixed Width file
Message
De
20/06/1997 17:55:43
 
 
À
20/06/1997 14:40:35
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00037175
Message ID:
00037236
Vues:
36
>>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform