Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Loop through record's fields
Message
De
21/09/2007 13:41:09
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
21/09/2007 12:31:16
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
01255535
Message ID:
01255994
Vues:
42
>>
>>And we already have a single method which will do it in one step:
>>
>>_vfp.datatoclip(,,3)
>>
>>Then it's only a matter of manipulating that one string on the clipboard into a format we want. The fields are separated by tabs, records by CRLF (or was it just CR?). Nice and easy.
>>
>>There's the trouble with the field names being in the first line, but it takes just two commands to remove it.
>[picking up forehead from the dented desk]
>And even things like copy file type sdf, which already remove the first line and takes only one line to add into string...

Sdf is more like a blind ASCII copy of the table, without the extra byte(s) before the first field, i.e. it's not delimited. And I've just caught SDF export in exporting nulls as zeros. _vfp.datatoclip(,,3) exports them as spaces. Other than that, either may be acceptable, depending on the intended use.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform