Midge -
Just set the file name variable to be exactly what you need:
SET VAR vFilename = ('Q:\RRSS\' + .vflname)
GATEWAY EXPORT TAB .vFilename SELECT ...
Sami
____________________________
Sami Aaron
Software Management Specialists
913-915-1971
[EMAIL PROTECTED]
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Nielsen
Midge D Contr 388 RANS/JT3
Sent: Thursday, January 10, 2008 8:45 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Gateway export to a variable filename
The only problem is I have to write it to another drive on the server.
Once I tell it to write to another drive, it won't read the filename, or
just writes it as vflname.
GATEWAY EXPORT TAB Q:\RRSS\.vflname SELECT FLDATE, FLLINE, REMARKS,
LOCAL_START, LOCAL_STOP, JON, RNGFLG, ORGNID, CNX, TE_TR, ZULU_START,
ZULU_STOP, AIRCRAFT, CALLSIGN, AC_QTY, AREA, MSL_FROM, MSL_TO, SECTORS
FROM SCHEDULE
Midge Nielsen
JT3/UTTR
Programmer
(801) 777-9653
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A.
Razzak Memon
Sent: Wednesday, 09 January, 2008 6:22PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Gateway export to a variable filename
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.
