I believe that I have found the problem. The table that posts the error has a DELETE trigger. If I use a cursor to delete, the rows the rows delete without error. If I use the "DELETE ROWS FROM PAYMENT WHERE InvNo IN (SELECT InvNo FROM tINVOICE)" it fails with a 2009 error and nothing is deleted.
John Engwer (412) 751-2433 From: [email protected] [mailto:[email protected]] On Behalf Of John Engwer Sent: Monday, July 11, 2011 9:17 PM To: RBASE-L Mailing List 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]
