Thanks Gérard, I was not aware that a cursor could handle long file names or that a Select * from sourcefile would give me the file in a cursor with the long file names. I thought this is great but then I discovered that copy to outfile type csv gives me the headers in the 10 character format.
Perhaps there is a work around? Thanks again, Joe On Tue, Apr 14, 2015 at 3:13 AM, Gérard LOCHON <[email protected]> wrote: > Hello. > > > > A table cannot have more than 10 chars as field name, out of a database. > > > > But ... cursors can ! > > > > So, if you first make a select from your table into a cursor, and then > copy it to a csv file, you'll get your > 10 char field names. > > > > Gérard. > > > > > > > > > > > Message du 14/04/15 08:42 > > De : "Joe Yoder" > > A : [email protected] > > Copie à : > > Objet : 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/cabqednwpb8esm20_dgoc8kwl3v1wp6sgfyoarho16cnf7jc...@mail.gmail.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.
