[RBASE-L] - Re: Gateway export to a variable filename

[A. Razzak Memon]

At 06:00 PM 1/9/2008, Midge Nielsen wrote:

I have been racking my brain trying to figure out how to gateway export
a file to a variable filename, and I can't get it.  Can anyone help?

Hello Midge,

Try the following examples.  I hope this is what you are looking for.

-- Example 01: Create MS Excel Workbook File (General)
CONNECT RRBYW14
SET VAR vFileName TEXT = 'CustomersByState.xls'
SET ERROR MESSAGE 2077 OFF
DELETE .vFileName
SET ERROR MESSAGE 2077 ON
GATEWAY EXPORT XLSW .vFileName SELECT ALL +
FROM Customer ORDER BY Company WHERE CustState = 'CA' +
OPTION COL_NAMES ON +
|SHOW_PROGRESS ON +
|BLANK_IF_ZERO ON +
|SHEET_NAME California +
|SHEET_INDEX 1 +
|ACTION OPENVIEW
CLEAR VARIABLE vFileName
RETURN

-- Example 02: Create MS Excel Workbook File (for MS Excel 2007)
CONNECT RRBYW14
SET VAR vFileName TEXT = 'CustomersByState.xlsx'
SET ERROR MESSAGE 2077 OFF
DELETE .vFileName
SET ERROR MESSAGE 2077 ON
GATEWAY EXPORT XLSW .vFileName SELECT ALL +
FROM Customer ORDER BY Company WHERE CustState = 'CA' +
OPTION COL_NAMES ON +
|SHOW_PROGRESS ON +
|BLANK_IF_ZERO ON +
|SHEET_NAME California +
|SHEET_INDEX 1 +
|ACTION OPENVIEW
CLEAR VARIABLE vFileName
RETURN

Very Best R:egards,

Razzak.