I am trying to Export information with Gateway to an Excel file from temp files created in RBASE. When I create a temp table for the order header information, these columns are primarily TEXT, INTEGER and a few NUMERIC, things go well and all information exports properly. All the columns are in the Excel file and all the rows of information exports.
When I create a temp table for ship to address using similar columns, TEXT, INTEGER and a few NUMERIC, the data exported through Gateway is not correct. Only about 15 of the 59 columns are exporting. And some of the columns not exporting are between columns that DO export. I have never encountered this problem in the 30 years I have exported data to Excel. Below is the information on the limits of Excel and I do not come even close to the limits. [cid:[email protected]] If I go into the table itself and export from there, not using the Gateway utility, all columns show up in the export. However I am not allowed to determine what to do with zeros or null values so zeros do not show in the Excel file. This will make me have to manually put zeros into the file. Here is the kicker. If I use CODE to do the EXPORT, everything works as expected. GATEWAY EXPORT xls (file<file://K-2K12/UserDesktops/jim/Desktop/shiptoinfo.XLS>name) SELECT ALL FROM (tablename) OPTION COL_NAMES ON |ACTION OPENVIEW |BLANK_IF_NULL ON |BLANK_IF_ZERO OFF Is there a setting someplace I am missing? James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/IA1PR02MB88987172172B0A94D189B387A0209%40IA1PR02MB8898.namprd02.prod.outlook.com.
