Look at UNLOAD as CSV.
----- Original Message ----- From: "J BLAUSTEIN" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, December 16, 2003 10:02 AM Subject: [RBASE-L] - Re: CSV report output > I had the same problem below - I was successful by projecting a temporary > table from the ODBC source and creating a index and then using it with a > view - > J > > > At 08:46 AM 12/16/2003 -0600, you wrote: > >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. > >================================================ > >
