Dennis, I tried your suggestion and it made matters worse. I now get the error message when I try to create the index on each table but the updates then work error free. ????
I project both tables where limit = 0, then insert the data. I project all of the columns in the source table but I only need a few of the columns in the temp tables. I did that because I am lazy. it's easier to hit the * key and not worry about listing each column needed. So I decided to project only the columns that I absolutely need and now it runs error free. There was a computed column in the original project and I thought it may be the culprit so I added it back in as a test. It made no difference, it still ran error free. I will experiment more when I get some free time. John From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis McGrath Sent: Friday, October 31, 2008 12:43 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Error during update 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] WWW.ENGWER.US
