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]
