Mike and Sami, Thank you for the suggestions. The reason why I was trying to use a report versus an unload or export from a view was due to the ODBC driver on the accounting package not handling views well.
Two tables are resident in Rbase with one in the accounting package linked through ODBC. (I made sure I used proper key columns etc.) When I query the view, the ODBC driver does not seem to handle it as the response time is more than slow, it takes 20-30 minutes to retrieve. However, a report on a view based on the resident tables only with a simple lookup in the ODBC table for the one field I need runs very fast. That is whyI was trying to use reports to create the CSV file. Plus using reports is more flexible than Export or Unload. I have found a work around by "creating a CSV" file with reports by adding commas for delimiters in a variable. It seems to be working very well and very fast. Thanks all. -Bob Thompson Technology Consultants 276 Chippewa LaPorte, IN 46350 219-324-2605 (Phone & Fax) 219-363-7441 (Cell) http://ttc.inc.home.comcast.net -----Original Message----- From: MikeB [SMTP:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 1:47 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CSV report output I had suggested this yesterday..I don't know why it wouldn't suit his needs. ----- Original Message ----- From: "Sami Aaron" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, December 16, 2003 2:51 PM Subject: [RBASE-L] - Re: CSV report output > Bob - > > You cando this: > > OUTPUT filename > UNLOAD DATA FOR tableview AS CSV > OUTPUT SCREEN > > Will this solve your problem? It will NOT include the column headings. > > Sami > > ----------------------------------------------------------------- > Sami Aaron > Software Management Specialists > 19312 W 63rd Terr > Shawnee KS 66218 > mailto:[EMAIL PROTECTED] > 913-915-1971 > > ----- Original Message ----- > From: "Thompson Technology Consultants" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > Sent: Tuesday, December 16, 2003 8:46 AM > Subject: [RBASE-L] - CSV report output > > > > 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 > > > > > > > > > >
