Karen, The second Gateway command with the same file name adds a second tab to the spreadsheet based in the SHEET_INDEX and TAB_NAME that you assign to it. If that Sheet Index already exists, it would guess that it would overwrite it.I think, although I have not tested that scenario. Javier, Javier Valencia, PE 913-829-0888 Office 913-915-3137 Cell 913-649-2904 Fax <mailto:[email protected]> [email protected] _____
From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, January 28, 2011 7:05 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Gateway Export Question Buddy: Wouldn't the second gateway export simply overwrite the same filename that the first one created? I didn't think that a gateway export would append data to a file that's already out there. Could be wrong, I've never tried it. That would present a problem to me because in my code I usually don't delete the file first, and would expect every gateway export to overwrite a file that's already out there. Karen DELETE C:\TEMP\MyWorkSheet.XLS GATEWAY EXPORT XLSW C:\TEMP\MyWorkSheet.XLS + SELECT blah blah... OPTION BLANK_IF_ZERO ON + |SHEET_INDEX 0 + |TAB_NAME something + |COL_NAMES ON ... GATEWAY EXPORT XLSW C:\TEMP\MyWorkSheet.XLS + SELECT Blah Blah .. OPTION BLANK_IF_ZERO ON + |SHEET_INDEX 1 + |TAB_NAME somethingElse + |COL_NAMES ON ... Notice the Sheet_INDEX option this is your key always start with 0 and continue from there. Buddy
