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
