Karen Strange I’ve always had trouble with the gateway if I didn’t first delete the file. I believe the default for SHEET_INDEX is 0 therefore calling for an overwrite. If the SHEET_INDEX is anything other than 0 it will append.
Buddy From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, January 28, 2011 9: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
