select rows before export (AREV Specific)
At 20 FEB 2003 06:00:47PM Chris E Snell wrote:
I need to export to Lotus 123 using a different sort method than SSELECT.
When I do this:
SELECT FCAST_INVRAW_LOTEX BY COLOR_CODE BY @ID
followed immediately by
EXPORT 123 FCAST_INVRAW_LOTEX
the export performs a
SSELECT FCAST_INVRAW_LOTEX
(it shows up in TCL previous command list)
I have read other online discussion articles indicating that selects before an export should work, any idea why it isn't for me?
AREV 3.1
Thanks in advance,
Chris.
At 20 FEB 2003 07:26PM Richard Hunt wrote:
Chris,
The EXPORT.123 program is "hard coded" to do a "SSELECT" (SELECT BY @ID).
When they say you can do a select before export, they really mean a select that reduces and not really a select that sorts.
Kinda a lame design. It was an oversight by the programmer.
If the EXPORT.123 program was mine to modify…
I would first copy the "$EXPORT.123" record and then edit the "SYSOBJ" file, record "$EXPORT.123" and locate the "SSELECT" and replace the "SSELECT" with " SELECT". Notice that I am adding a blank space before the "SELECT" so that "SSELECT" and " SELECT" remain the same length. You must maintain the exact length in that area of the run code. Now given that it is Revelation's program, I would not do that since it would kinda infringe on copyright.
At 24 FEB 2003 05:48PM Warren wrote:
Source code for EXPORT.123 should be included in the REVSRC file on the utilities disk (version 2.1+ I believe).
Modify at your own risk.
If it's like EXPORT.ASCII it should be called as a subroutine from EXPORT. If that is the case you can take the source code and compile it as myexport.123 or whatever and write your own shell to take the place of EXPORT to call myexport.123.
I modified EXPORT.ASCII in this manner so I could leave the default export.ascii intact for use by existing programs.