Midge, Can you try an & variable? GATEWAY EXPORT TAB Q:\RRSS\&vflname
Jan -----Original Message----- From: "Nielsen Midge D Contr 388 RANS/JT3" <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 10 Jan 2008 07:44:42 -0700 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.
