Thank You John. That seems to work just fine. I will implement when I get back into office next week.
Thanks to everyone else who responded to this thread. 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 4:25 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: -ERROR- Table ppsout does not exist! At 03:29 PM 12/01/2011, Coxen, Dayle wrote: >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 Hello Dayle, You have found an issue in R:BASE eXtreme in regards to the JOIN command and how the database table list is not being updated accordingly. The problem is not with the JOIN command itself, as much as it is a "refresh" issue for the database tables. JOIN is still a supported command, and users are not required to change it to another variation of R:BASE syntax. To test the display of the report, you can create a view with an INNER JOIN. -- CONNECT wdoss DROP TABLE ppsb NOCHECK DROP TABLE ppsbt NOCHECK DROP VIEW ppsout CREATE TABLE ppsb (ssnb TEXT 11) LOAD ppsb FROM rpt1.dat PROJECT ppsbt FROM pps USING ssn,firstnme,lastnme,crew CREATE VIEW ppsout AS SELECT ALL FROM ppsb t1 + INNER JOIN ppsbt t2 ON t1.ssnb=t2.ssnb PRINT ppsout ORDER BY crew + OPTION SCREEN|WINDOW_STATE MAXIMIZED + |ZOOM_TYPE PERCENTAGE|ZOOMPERCENTAGE 98 RETURN -- John
