Thanks for the suggestion. I tried PAUSE FOR 5 in place of the CONNECT. Still results in "-ERROR- Table ppsout does not exist!"
Dayle Coxen Florida DOT (850) 410-5635 From: [email protected] [mailto:[email protected]] On Behalf Of Alastair Burr Sent: Thursday, December 01, 2011 1:33 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: -ERROR- Table ppsout does not exist! Try putting a PAUSE of a few seconds between the JOIN and PRINT commands in case the table is not created quickly enough. Regards, Alastair. From: Coxen, Dayle<mailto:[email protected]> Sent: Thursday, December 01, 2011 6:11 PM To: RBASE-L Mailing List<mailto:[email protected]> Subject: [RBASE-L] - -ERROR- Table ppsout does not exist! 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
