Alastair – That’s a good point. So I tested with an initial CONNECT.
CONNECT wdoss DROP ppsb DROP ppsbt DROP ppsout 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 98 RETURN Same results. The above code just does not find the table “ppsout” unless I do another connect right after the join. The code below works fine: CONNECT wdoss DROP ppsb DROP ppsbt DROP ppsout 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 CONNECT wdoss PRINT ppsout ORDER BY crew + OPTION SCREEN|WINDOW_STATE MAXIMIZED + |ZOOM_TYPE percentage 98 RETURN Thanks, Dayle Coxen Florida DOT (850) 410-5635 From: [email protected] [mailto:[email protected]] On Behalf Of Alastair Burr Sent: Thursday, December 01, 2011 2:27 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: -ERROR- Table ppsout does not exist! Well, I know age is catching up and my eyes are not what they used to be but I don’t see a CONNECT in the code on your original post... Regards, Alastair. From: Coxen, Dayle<mailto:[email protected]> Sent: Thursday, December 01, 2011 6:45 PM To: RBASE-L Mailing List<mailto:[email protected]> Subject: [RBASE-L] - Re: -ERROR- Table ppsout does not exist! 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
