At 09:50 AM 3/7/2009, John Engwer wrote:
I am trying to use the print command to create an XLS file
with customer names. As the file is being created, I get
an error as follows: File Error: Data may have been lost.
John,
Without knowing all details on your end, especially the
table structure, etc., try the following options and see
what you get.
01. A simple approach ...
GATEWAY EXPORT XLS filename.xls +
SELECT * FROM tableviewname +
WHERE clause ... +
ORDER BY clause ... +
OPTION COL_NAMES ON +
|BLANK_IF_ZERO OFF +
|SHEET_NAME sheet name +
|ACTION OPENVIEW
Example:
CONNECT RRBYW14
GATEWAY EXPORT XLS Customers.xls +
SELECT * FROM Customer +
WHERE Company IS NOT NULL +
ORDER BY Company +
OPTION COL_NAMES ON +
|BLANK_IF_ZERO OFF +
|ACTION OPENVIEW
RETURN
02. A custom approach ...
Define a custom R:BASE Gateway (.rgw) Specification
file with all details and use the following syntax:
Example:
CONNECT RRBYW14
GATEWAY EXPORT XLS Customers.xls +
SELECT * FROM Customer +
WHERE Company IS NOT NULL +
ORDER BY Company +
OPTION SPECIFICATION_FILE_NAME customerdata.rgw +
|ACTION OPENVIEW
RETURN
Hope that helps!
Very Best R:egards,
Razzak.
