Long ago I learned how to create data dump to text file snippets by browsing a table and then using the export option to build the statement for me and then copy it out of the command window and make it into a procedure. any way I need to export the football season (a 4-digit) integer as a string with quotes on each side.
It starts out looking something like; COPY TO c:\alldat2\special\tmppfbstats.txt FOR pfbstats2.year=2013 FIELDS Pfbstats2.tmid, Pfbstats2.year, . etc and then DELIMITED WITH '"' WITH CHAR , How do I export Pfbstats2.year as a 4-character string like "2013", instead of 2013, How do I export a date to the yyyy-mm-dd, format I need. And of course I think I will change the .t. or .f. into "Y" or "N" If I get this figured out, I should be able to update my mysql database with 2-clicks and 1-update query from mysql workbench. Gary Jeurink --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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/AE114085EBFD4270BE01E2B79E016442@OwnerPC ** 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.
