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

Author: Michael Madigan

Posted: 2015-04-14 at 02:22:19

One way would be to then copy the csv to a memo field, replace the first line with the field names you want, then "copy memo"  memo field back to a csv file

the first like would be something like '"header i","header2","header3" '

or

You can use low level file manipulation to delete the first line and replace it with your custom line.   

I think this will work. 

From: Joe Yoder <joe@wheypower.com>

To: profoxtech@leafe.com

Sent: Tuesday, April 14, 2015 2:42 AM

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/804755022.3023460.1428996139095.JavaMail.yahoo@mail.yahoo.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 Michael Madigan