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:[email protected]] On Behalf Of Dave Crozier Sent: 14 April 2015 08:27 To: [email protected] 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:[email protected]] On Behalf Of Joe Yoder Sent: 14 April 2015 07:42 To: [email protected] 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: [email protected] 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/[email protected] ** 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.
