Bernie, I don't think it is memory. I have 8 GB. It has something to do with the trigger that I have assigned to the table. If I delete the "delete trigger" it works or if I leave the trigger installed and use a cursor to perform the deletes it also works.
John Engwer (412) 751-2433 From: [email protected] [mailto:[email protected]] On Behalf Of Bernard Lis Sent: Wednesday, July 13, 2011 9:07 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Delete with sub-select 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 <mailto:[email protected]> To: RBASE-L Mailing List <mailto:[email protected]> 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]
