I seem to remember a thread about outputting a report to CSV format, but I could not find it.
I am writing an EDI application and need to create a CSV file. I know I can EXPORT through Gateway, but it poses a particular problem. I have to get one field of information from an accounting package through ODBC. I have tried creating a view to include this info, but the ODBC driver is so extremely slow, (this is not an Rbase problem) it makes the file creation time unrealistic. Also, I have not figured out how to turn off the column headings in the export file. (I tried Set Head Off, but that did not accomplish the task) I can create a report, and use a lookup variable to the ODBC table and the speed is fine! (Evidently, their ODBC driver does not handle views very well. I did insure my linking columns where properly keyed) However, while reports give me much more flexibility in creating a data file, it does not have a CSV output format. Any ideas would be appreciated. Thanks, -Bob Thompson Technology Consultants 276 Chippewa LaPorte, IN 46350 219-324-2605 (Phone & Fax) 219-363-7441 (Cell) http://ttc.inc.home.comcast.net --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [EMAIL PROTECTED] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
