Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Loop through record's fields
Message
From
21/09/2007 13:41:09
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
21/09/2007 12:31:16
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01255535
Message ID:
01255994
Views:
41
>>
>>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform