Hi John, Perhaps the quantity of invoice numbers from tInvoice creates a file in memory that exceeds your available memory.
Bernie Lis ----- Original Message ----- From: John Engwer To: RBASE-L Mailing List Sent: Monday, July 11, 2011 9:17 PM Subject: [RBASE-L] - Delete with sub-select I am getting an error on certain tables when I use a DELETE with a WHERE clause that has a sub-select. DELETE ROWS FROM PAYMENT WHERE InvNo IN (SELECT InvNo FROM tINVOICE) Error - I/O problems - check for a full disk (2009) I use the same sub-select in DELETEs on two other tables without errors. No errors when I unload/reload the database. No errors with AUTOCHK. V8 latest release. Does anyone know why I may be getting the 2009 error? John Engwer Engwer & Associates 2449 Scenic Ridge Drive North Huntingdon, PA 15642 Phone: (412) 751-2433 Email: [email protected]
