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. Dayle Coxen Florida DOT 850-410-5635
