I personally stay away from the project and join commands because it puts locks on the database.
Dan Goldberg -----Original Message----- From: Dennis McGrath Sent: Thursday, December 01, 2011 12:45 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: -ERROR- Table ppsout does not exist! I have been having some of the same problems. It seems to be related to creating a table with PROJECT or JOIN and trying to print a report from it. In some scenarios it works OK, but others it does not. I cannot find a pattern. My fix is to always create tables using CREATE TEMP TABLE... Then I use INSERT OR LOAD to populate these tables. So far this has fixed all my printing problems in this regard. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Coxen, Dayle Sent: Thursday, December 01, 2011 2:30 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: -ERROR- Table ppsout does not exist! Hello John - I think I applied all extensions you suggested. I tried the following. It throws the same error. CONNECT wdoss 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 Thank you. Dayle Coxen Florida DOT (850) 410-5635 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of John Minyo II Sent: Thursday, December 01, 2011 2:47 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: -ERROR- Table ppsout does not exist! 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
