Tom Did you know that RBase has the ability to nest joins ( INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN) there is no need to nest views due to previous limitations imposed on nesting joins. The nesting of joins is available in v7.6.
Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 > >From: "[email protected]" <[email protected]> >To: RBASE-L Mailing List <[email protected]> >Sent: Fri, March 4, 2011 5:47:05 AM >Subject: [RBASE-L] - Help with a view > >Good Morning > >I know fully well that i am missing something in this, but I am hoping someone >with keen eyes can spot the error as I cannot. This is in the most recent >version of 7.6-but again, i think it is me and not the software. > >I am getting an error: >"I/O Error reading beyond file size of 0 for C:\DOCUME~1\THOMAS~1\LOCALS~1\. >-ERROR- I/O problems - Check for a full disk. (2009) >-ERROR- INTERNAL ERROR - in sort processing (2290) ><WARNING> No rows exist or satisfy the specified clause. (2059)" > >while running the following code. The view (myjob) from which the data is >being >called exists and is fully populated as expected. The Table (placemaster) is >also populated. Code in question is: > >CREATE VIEW newaddies + >(locationnumber, idnum, firstname, lastname, prefferedname, + >fullname, lookupname, homeaddress, homecsz, gender, + >stafftitle,extension, phonehome, publish, cellnumber, + >termstart,lastmodified, retiredate, decdate, rushnum, + >rushnumber, dirsequence, emailaddr, officename, + >officeaddr, + >ofccsz, + >addrpref, mailpref, dirquan, officeph, spouse ) AS + >SELECT t1.locationnumber,t1.idnum,t1.firstname,t1.lastname,t1.prefferedname,+ >t1.fullname, t1.lookupname,t1.homeaddress, t1.homecsz, t1.gender, + >t1.stafftitle,t1.extension,t1.phonehome,t1.publish,t1.cellnumber,+ >t1.termstart,t1.lastmodified,t1.retiredate,t1.decdate,(CTXT(t1.rushnum)),+ >t1.rushnum,t1.dirsequence,t1.emailaddr,t2.orgname,+ >(IFEXISTS(t2.ofcaddr2,t2.ofcaddr2,t2.ofcaddr1)),+ >(t2.ofccity + ', ' & t2.ofcstate &t2.ofcpocode & t2.ofccountry),+ >t1.addrpref,t1.mailpref,t2.dirquan,t2.phofc,t1.spouse FROM myjob t1, >placemaster >t2 + >WHERE t1.locationnumber = t2.locationnumber ORDER BY t1.locationnumber, >t1.lastname > >Thank you for your consideration and help. >Have a great day. >tom > >Tom Eldred >Administrative Associate >County Road Association of Michigan
