That's all very well but I thought he wanted long, meaningful headers like "Home telephone"? In which case some post hoc tinkering with the file would be necessary ...

Paul Newton

-----Original Message-----

From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Dave Crozier

Sent: 14 April 2015 08:27

To: profoxtech@leafe.com

Subject: RE: Creating SDF files with the database caption as header names

As Gerard says, select your data into a cursor with named fields:

Select all <field1> as <Name1>,

<field2> as <Name2> ....

>From <table> into cursor <cursor>

Where <where>

Select <cursor>

Copy to <output> type CSV

Dave

-----Original Message-----

From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Joe Yoder

Sent: 14 April 2015 07:42

To: profoxtech@leafe.com

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

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/9A8106AFB0EF9B44B69045C4448935A284281D4A@NLBAWEXMBX1.infor.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.