Try indexing cust_no on both tables. You wouldn't think this was necessary, but I have found that indexes help a lot.
Dennis ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Engwer Sent: Friday, October 31, 2008 11:28 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Error during update I am getting a "Disk problems - Please check disk and files. (2036)" when I try to update a temporary table. The error appears once and then the table updates properly. The two temp tables have exactly the same columns, projected from the same source table. T2007 contains 2007 data and t2008 contains 2008 data. No indexes on either table. Here is my code: This update posts the error. UPDATE t2008 SET receipt ='Y' FROM t2008 t1,t2007 t2 WHERE t1.cust_no = t2.cust_no This update does not post the error. UPDATE t2007 SET receipt = 'D' FROM t2007 t1,t2008 t2 WHERE t1.cust_no = t2.cust_no AND t2.receipt = 'Y' Does anyone know what may be happening here? John Engwer Engwer & Associates 2449 Scenic Ridge Drive North Huntingdon, PA 15642-2120 Phone: 412 751-2433 Email: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> WWW.ENGWER.US<http://www.ENGWER.US>
