I agree with Tony, your problem seems to be with CREATE VIEW (rushnum, rushnumber) AS SELECT (CTXT(t1.rushnum)), t1.rushnum .... ETC
rushnum seems to be an INTEGER which you are also defining as its TEXT equivalent. However you got your names and definitions reversed. My suggestion reverse the view column names ( rushnumber,rushnum ) this way rushnum stays defined as an INTEGER. Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 > >From: A.G. IJntema <[email protected]> >To: RBASE-L Mailing List <[email protected]> >Sent: Fri, March 4, 2011 7:24:13 AM >Subject: [RBASE-L] - RE: Help with a view > > >Hi Tom, > >I am not sure but it looks to me that your problem is situated here: > >(CTXT(t1.rushnum)),+ >t1.rushnum, + > >rushnum is also used as an alias – as an INTEGER I assume - and my assumption >is that this is not correct. > >My advise is to create the query piece by piece so that you are able to find >out >where it goes wrong. > >BTW have you thought about making use of a left join in case the there is no >match in the second table. > >Hope this helps > >Tony > > >From:[email protected] [mailto:[email protected]] On Behalf Of >[email protected] >Sent: vrijdag 4 maart 2011 12:47 >To: RBASE-L Mailing List >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
