Re: Creating SDF files with the database caption as header names

Author: Alan Bourke

Posted: 2015-04-14 at 03:39:40

You'd have to roll your own.

use mytable

Set textmerge on noshow

set textmerge to myfile.csv

lnFields = Fcount("mytable")

For x = 1 to lnFields

\\<<Field(x, "mytable", 1)>><<iif(x<lnFields, ",", "")>>

Endfor

scan

\\<<field1>>,<<field2>>,<<field3>>

endscan

Set textmerge off

set textmerge to

--

Alan Bourke

alanpbourke (at) fastmail (dot) fm

On Tue, 14 Apr 2015, at 07:42 AM, Joe Yoder wrote:

> When I browse a table from a database with some user defined field names

> in

> it I see long meaningful field names as headers but when I copy to file

> as

> type CSV I get 10 character gobletty goop for field headers.

>

> Is there a built in way to have VFP copy to a CSV file using the field

> captions from the dictionary for field headers? If not - how do I

> programatically access the captions to write my own?

>

> Thanks in advance,

>

> Joe

>

>

> --- StripMime Report -- processed MIME parts ---

> multipart/alternative

> text/plain (text body -- kept)

> text/html

> ---

>

[excessive quoting removed by server]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/1429000780.138952.253448833.577E7A77@webmail.messagingengine.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2015 Alan Bourke