John, You don't say whether you are doing this PROJECTion in a form but, if you are, why not CREATE the temp tables in the form's On Before Start EEP?
That way you will be sure that the tables are correct and you only need to insert the data that you want. If not in a form the difference between CREATE and PROJECT with zero limit must be marginal and your data still gets added. Sometimes the lazy way may not turn out to be the quickest!! Mind you, I'm lazy enough to have a permanent table with all my temp tables defined in it so I don't have to bother with them unless I need to create a new one. Regards, Alastair. ----- Original Message ----- From: John Engwer To: RBASE-L Mailing List Sent: Friday, October 31, 2008 5:53 PM Subject: [RBASE-L] - RE: Error during update 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 ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.8.5/1758 - Release Date: 31/10/2008 08:22
