Hi Gary, There are no customer numbers that are null and the receipt column can contain multiple indicators (it may not be null).
John From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Gary Wendike Sent: Saturday, November 01, 2008 1:42 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Error during update John, I would check the following... 1 Are there any cust_no values listed as null? If so what happens if you set eqnull on? 2 Try adding "and t1.receipt IS NULL" to the first statement, assuming you are updating only the cust_no that have not been updated so far. Gary ----- Original Message ---- From: John Engwer <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Friday, October 31, 2008 11:27:35 AM 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 <http://www.engwer.us/>
