John: I'm surprised when you talk of "tightening" up the code that you still included the original "JOIN" command. It's been probably over a decade since I've used JOIN, INTERSECT, SUBTRACT or any of those other old legacy commands and have instead gone to true SQL syntax to do the same thing.
Are these considered obsolete commands? Or still fully supported with no chance of ever going away in some future RBase version? Karen In a message dated 12/1/2011 1:47:07 PM Central Standard Time, [email protected] writes: > 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 >
