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
