Thursday, June 24, 2021
Tip of the Day: Column Reordering Options for File Gateway Exports
Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.........: 10.5.3.20624 or higher
Sections......: File Gateway
Keywords......: Export, SELECT, Column, Order, Specification File
Did you know the File Gateway and Export functionality has been enhanced
with new column reordering functionality?
When using the GATEWAY Export and SELECT command syntax, along with a
Specification File, a new command file parameter was implemented to
maintain the SELECT column order for the output.
The DATASET_FIELD_ORDER parameter specifies the export will follow the
SELECT clause column order, rather than the field order in the .RGW
specification file, when a specification file is used as an OPTION
parameter. The default is OFF.
GATEWAY EXPORT XLS StaffList.xls +
SELECT DepartmentID,HireDate,LastName FROM Staff +
ORDER BY DepartmentID ASC, LastName ASC +
OPTION TAB_NAME Staff +
|SPECIFICATION_FILE_NAME StaffExp.rgw +
|DATASET_FIELD_ORDER ON
RETURN
Within the Gateway Export Wizard, sorting the fields in the column list
page is now supported to reorder the output. The column order may be
rearranged by dragging the columns within the list.
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/1MOiwt-1lcHQ02myd-00QG2b%40mrelay.perfora.net.
