At 01:11 PM 12/01/2011, Coxen, Dayle wrote:
Hello all -
Maybe someone can enlighten me.
I am converting a .CMD file from 7.6 to 9.1.
I isolated the issue to the following 11 lines of code.
When I trace the below .RMD, I get the message "-ERROR- Table ppsout
does not exist!" after executing line 10.
The report "ppsout" uses a table of the same name.
01 DROP ppsb
02 DROP ppsbt
03 DROP ppsout
04 CREATE TABLE ppsb (ssnb TEXT 11)
05 LOAD ppsb FROM rpt1.dat
06 PROJECT ppsbt FROM pps USING ssn, firstnme,lastnme,crew
07 JOIN ppsb USING ssnb WITH ppsbt USING ssn FORMING ppsout
08 PRINT ppsout ORDER BY crew +
09 OPTION SCREEN|WINDOW_STATE MAXIMIZED +
10 |ZOOM_TYPE percentage 98
11 RETURN
When I exit the trace and use Database Explorer to look for the
table (ppsout), it is there.
It contains the rows and columns expected.
When I open the report (ppsout) with report designer and select the
preview tab it looks fine.
ppsb, ppsbt both contain values that I expected.
The only way I could get the report to run was to add a CONNECT to
the database between lines 07 and 08.
It then works fine.
Thanks in advance.
Hello Dayle,
Now would be the best time to tighten up the code, as you may see
some differences using the following.
The DROP commands were extended with all available parameters, along
with ZOOMPERCENTAGE for your PRINT command.
DROP TABLE ppsb NOCHECK
DROP TABLE ppsbt NOCHECK
DROP TABLE ppsout NOCHECK
CREATE TABLE ppsb (ssnb TEXT 11)
LOAD ppsb FROM rpt1.dat
PROJECT ppsbt FROM pps USING ssn,firstnme,lastnme,crew
JOIN ppsb USING ssnb WITH ppsbt USING ssn FORMING ppsout
PRINT ppsout ORDER BY crew +
OPTION SCREEN|WINDOW_STATE MAXIMIZED +
|ZOOM_TYPE PERCENTAGE|ZOOMPERCENTAGE 98
RETURN
Please try the above.
Best regards,
John Minyo II
R:BASE Technologies, Inc.
Customer Service
