ta aparecendo a instrucao SQL e nao zera

ALTER TABLE matestoquedev DISABLE TRIGGER ALL; ALTER TABLE matestoquedevitem DISABLE TRIGGER ALL; ALTER TABLE atendrequi DISABLE TRIGGER ALL; ALTER TABLE atendrequiitem DISABLE TRIGGER ALL; ALTER TABLE matrequiitem DISABLE TRIGGER ALL; ALTER TABLE matestoqueinimei DISABLE TRIGGER ALL; ALTER TABLE matestoqueini DISABLE TRIGGER ALL; ALTER TABLE empnota DISABLE TRIGGER ALL; ALTER TABLE matestoqueitemlote DISABLE TRIGGER ALL; ALTER TABLE matestoqueitemfabric DISABLE TRIGGER ALL; DELETE FROM matestoquedev WHERE matestoquedevitem.m46_codmatestoquedev=m45_codigo and matestoquedevitemmei.m47_codmatestoquedevitem = matestoquedevitem.m46_codigo and matestoquedevitemmei.m47_codmatestoqueitem = matestoqueitem.m71_codlanc and matestoqueitem.m71_codmatestoque = matestoque.m70_codigo and matestoque.m70_coddepto = 10; DELETE FROM matestoquedevitem WHERE matestoquedevitemmei.m47_codmatestoquedevitem = m46_codigo and matestoquedevitemmei.m47_codmatestoqueitem = matestoqueitem.m71_codlanc and matestoqueitem.m71_codmatestoque = matestoque.m70_codigo and matestoque.m70_coddepto = 10; DELETE FROM matestoquedevitemmei WHERE m47_codmatestoqueitem = matestoqueitem.m71_codlanc and matestoqueitem.m71_codmatestoque = matestoque.m70_codigo and matestoque.m70_coddepto = 10; DELETE FROM far_retiradarequi USING matrequi WHERE fa07_i_matrequi = m40_codigo and m40_depto = 10; DELETE FROM atendrequi WHERE atendrequiitem.m43_codatendrequi = m42_codigo and atendrequiitemmei.m44_codatendreqitem = atendrequiitem.m43_codigo and atendrequiitemmei.m44_codmatestoqueitem = matestoqueitem.m71_codlanc and matestoqueitem.m71_codmatestoque = matestoque.m70_codigo and matestoque.m70_coddepto = 10; DELETE FROM atendrequiitem WHERE atendrequiitemmei.m44_codatendreqitem = m43_codigo and atendrequiitemmei.m44_codmatestoqueitem = matestoqueitem.m71_codlanc and matestoqueitem.m71_codmatestoque = matestoque.m70_codigo and matestoque.m70_coddepto = 10; DELETE FROM atendrequiitemmei WHERE m44_codmatestoqueitem = matestoqueitem.m71_codlanc and matestoqueitem.m71_codmatestoque = matestoque.m70_codigo and matestoque.m70_coddepto = 10; DELETE FROM matrequiitem WHERE matrequi.m40_codigo = m41_codmatrequi and matrequi.m40_depto = 10; DELETE FROM matrequi WHERE matrequi.m40_depto = 10; DELETE FROM matestoqueini WHERE matestoqueinimei.m82_matestoqueini = m80_codigo and matestoqueitem.m71_codlanc = matestoqueinimei.m82_matestoqueitem and matestoqueitem.m71_codmatestoque = matestoque.m70_codigo and matestoque.m70_coddepto = 10; DELETE FROM matestoqueinimeiari WHERE m49_codmatestoqueinimei = matestoqueinimei.m82_codigo and matestoqueinimei.m82_matestoqueitem = matestoqueitem.m71_codlanc and matestoqueitem.m71_codmatestoque = matestoque.m70_codigo and matestoque.m70_coddepto = 10; DELETE FROM matestoqueinimeimdi WHERE m50_codmatestoqueinimei = matestoqueinimei.m82_codigo and matestoqueinimei.m82_matestoqueitem = matestoqueitem.m71_codlanc and matestoqueitem.m71_codmatestoque = matestoque.m70_codigo and matestoque.m70_coddepto = 10; DELETE FROM matestoqueinimei WHERE matestoqueitem.m71_codlanc = m82_matestoqueitem and matestoqueitem.m71_codmatestoque = matestoque.m70_codigo and matestoque.m70_coddepto = 10; --DELETE FROM empnotaele -- WHERE matestoqueitemnota.m74_codempnota = e70_codnota -- AND matestoqueitemnota.m74_codmatestoqueitem = matestoqueitem.m71_codlanc -- AND matestoqueitem.m71_codmatestoque = matestoque.m70_codigo -- AND matestoque.m70_coddepto = 10; --DELETE FROM empnotaord -- WHERE matestoqueitemnota.m74_codempnota = m72_codnota -- AND matestoqueitemnota.m74_codmatestoqueitem = matestoqueitem.m71_codlanc -- AND matestoqueitem.m71_codmatestoque = matestoque.m70_codigo -- AND matestoque.m70_coddepto = 10; --DELETE FROM empnota -- WHERE matestoqueitemnota.m74_codempnota = e69_codnota -- AND matestoqueitemnota.m74_codmatestoqueitem = matestoqueitem.m71_codlanc -- AND matestoqueitem.m71_codmatestoque = matestoque.m70_codigo -- AND matestoque.m70_coddepto = 10; DELETE FROM matestoqueitemnotafiscalmanual WHERE matestoqueitemnotafiscalmanual.m79_matestoqueitem = matestoqueitem.m71_codlanc and matestoqueitem.m71_codmatestoque = matestoque.m70_codigo and matestoque.m70_coddepto = 10; DELETE FROM matestoqueitemnota WHERE matestoqueitemnota.m74_codmatestoqueitem = matestoqueitem.m71_codlanc and matestoqueitem.m71_codmatestoque = matestoque.m70_codigo and matestoque.m70_coddepto = 10; DELETE FROM matestoqueitemoc WHERE matestoqueitemoc.m73_codmatestoqueitem = matestoqueitem.m71_codlanc and matestoqueitem.m71_codmatestoque = matestoque.m70_codigo and matestoque.m70_coddepto = 10; DELETE FROM matestoqueitemunid WHERE matestoqueitemunid.m75_codmatestoqueitem = matestoqueitem.m71_codlanc and matestoqueitem.m71_codmatestoque = matestoque.m70_codigo and matestoque.m70_coddepto = 10; DELETE FROM matestoqueitemlote WHERE m77_matestoqueitem = matestoqueitem.m71_codlanc and matestoqueitem.m71_codmatestoque = matestoque.m70_codigo and matestoque.m70_coddepto = 10; DELETE FROM matestoqueitemfabric WHERE m78_matestoqueitem = matestoqueitem.m71_codlanc and matestoqueitem.m71_codmatestoque = matestoque.m70_codigo and matestoque.m70_coddepto = 10; DELETE FROM far_retiradaitemlote WHERE fa09_i_matestoqueitem = matestoqueitem.m71_codlanc and matestoqueitem.m71_codmatestoque = matestoque.m70_codigo and matestoque.m70_coddepto = 10; DELETE FROM matestoqueitem WHERE m71_codmatestoque = matestoque.m70_codigo and matestoque.m70_coddepto = 10; DELETE FROM matestoque WHERE m70_coddepto = 10; ALTER TABLE matestoquedev ENABLE TRIGGER ALL; ALTER TABLE matestoquedevitem ENABLE TRIGGER ALL; ALTER TABLE atendrequi ENABLE TRIGGER ALL; ALTER TABLE atendrequiitem ENABLE TRIGGER ALL; ALTER TABLE matrequiitem ENABLE TRIGGER ALL; ALTER TABLE matestoqueinimei ENABLE TRIGGER ALL; ALTER TABLE matestoqueini ENABLE TRIGGER ALL; ALTER TABLE empnota ENABLE TRIGGER ALL; ALTER TABLE matestoqueitemlote ENABLE TRIGGER ALL; ALTER TABLE matestoqueitemfabric ENABLE TRIGGER ALL; 

Autor: Paulo Delphino