Monday, October 7, 2019
Tip of the Day: Overwrite Workbook Command Option
Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.........: 10.5.1.30926 or higher
Sections......: Commands
Keywords......: GATEWAY, Export, XLSW, Workbook, Overwrite, Sheet,
Did you know you can optionally overwrite an Excel workbook using the GATEWAY
EXPORT command syntax?
A new GATEWAY EXPORT parameter, OVERWRITE_SHEET, was introduced to specify that
an existing file with the same name will be overwritten with the new dataset.
GATEWAY EXPORT XLSW NewData.xlsx +
SELECT ALL FROM CustData +
OPTION OVERWRITE_SHEET ON
The new OVERWRITE_SHEET parameter was added if an application does not need to
verify a file already exists before overwriting the file, and to not interfere
with the existing export behavior.
Very Best R:egards,
Razzak.
https://www.rbase.com
http://www.facebook.com/rbase/
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/201910072301.x97N13hH003967%40atl4mhob07.registeredsite.com.
