----- Original Message ----- From: "jan johansen" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, January 10, 2008 9:53 AM Subject: [RBASE-L] - Re: Gateway export to a variable filename
> Midge, > > Can you try an & variable? > GATEWAY EXPORT TAB Q:\RRSS\&vflname That also should work... > 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. >
