Index: trunk/ippTools/share/addtool_revertminidvodbprocessed.sql
===================================================================
--- trunk/ippTools/share/addtool_revertminidvodbprocessed.sql	(revision 28553)
+++ trunk/ippTools/share/addtool_revertminidvodbprocessed.sql	(revision 28558)
@@ -5,3 +5,3 @@
     AND addRun.minidvodb_name = minidvodbRun.minidvodb_name
     AND minidvodbProcessed.fault != 0
-    AND minidvodbRun.state = 'new'
+    AND minidvodbRun.state = 'merged'
Index: trunk/ippTools/share/dettool_revertdetrunsummary.sql
===================================================================
--- trunk/ippTools/share/dettool_revertdetrunsummary.sql	(revision 28553)
+++ trunk/ippTools/share/dettool_revertdetrunsummary.sql	(revision 28558)
@@ -1,3 +1,8 @@
 DELETE FROM detRunSummary
+USING detRunSummary, detRun
 WHERE
     fault != 0
+AND
+    state = 'run'
+AND
+    detRunSummary.det_id = detRun.det_id
Index: trunk/ippTools/share/dettool_revertnormalizedexp.sql
===================================================================
--- trunk/ippTools/share/dettool_revertnormalizedexp.sql	(revision 28553)
+++ trunk/ippTools/share/dettool_revertnormalizedexp.sql	(revision 28558)
@@ -1,3 +1,8 @@
 DELETE FROM detNormalizedExp
+USING detNormalizedExp, detRun
 WHERE
     fault != 0
+AND
+    state = 'run'
+AND
+    detNormalizedExp.det_id = detRun.det_id
Index: trunk/ippTools/share/dettool_revertnormalizedimfile.sql
===================================================================
--- trunk/ippTools/share/dettool_revertnormalizedimfile.sql	(revision 28553)
+++ trunk/ippTools/share/dettool_revertnormalizedimfile.sql	(revision 28558)
@@ -1,3 +1,8 @@
 DELETE FROM detNormalizedImfile
+USING detNormalizedImfile, detRun
 WHERE
     fault != 0
+AND
+    state = 'run'
+AND
+    detNormalizedImfile.det_id = detRun.det_id
Index: trunk/ippTools/share/dettool_revertnormalizedstat.sql
===================================================================
--- trunk/ippTools/share/dettool_revertnormalizedstat.sql	(revision 28553)
+++ trunk/ippTools/share/dettool_revertnormalizedstat.sql	(revision 28558)
@@ -1,3 +1,8 @@
 DELETE FROM detNormalizedStatImfile
+USING detNormalizedStatImfile, detRun
 WHERE
     fault != 0
+AND
+    state = 'run'
+AND
+    detNormalizedStatImfile.det_id = detRun.det_id
Index: trunk/ippTools/share/dettool_revertprocessedexp.sql
===================================================================
--- trunk/ippTools/share/dettool_revertprocessedexp.sql	(revision 28553)
+++ trunk/ippTools/share/dettool_revertprocessedexp.sql	(revision 28558)
@@ -1,3 +1,8 @@
 DELETE FROM detProcessedExp
+USING detProcessedExp, detRun
 WHERE
     fault != 0
+AND
+    state = 'run'
+AND
+    detProcessedExp.det_id = detRun.det_id
Index: trunk/ippTools/share/dettool_revertprocessedimfile.sql
===================================================================
--- trunk/ippTools/share/dettool_revertprocessedimfile.sql	(revision 28553)
+++ trunk/ippTools/share/dettool_revertprocessedimfile.sql	(revision 28558)
@@ -1,3 +1,8 @@
 DELETE FROM detProcessedImfile
+USING detProcessedImfile, detRun
 WHERE
     fault != 0
+AND
+    state = 'run'
+AND
+    detProcessedImfile.det_id = detRun.det_id
Index: trunk/ippTools/share/dettool_revertresidexp.sql
===================================================================
--- trunk/ippTools/share/dettool_revertresidexp.sql	(revision 28553)
+++ trunk/ippTools/share/dettool_revertresidexp.sql	(revision 28558)
@@ -1,3 +1,8 @@
 DELETE FROM detResidExp
+USING detResidExp, detRun
 WHERE
     fault != 0
+AND
+    state = 'run'
+AND
+    detResidExp.det_id = detRun.det_id
Index: trunk/ippTools/share/dettool_revertresidimfile.sql
===================================================================
--- trunk/ippTools/share/dettool_revertresidimfile.sql	(revision 28553)
+++ trunk/ippTools/share/dettool_revertresidimfile.sql	(revision 28558)
@@ -1,3 +1,8 @@
 DELETE FROM detResidImfile
+USING detResidImfile, detRun
 WHERE
     fault != 0
+AND
+    state = 'run'
+AND
+    detResidImfile.det_id = detRun.det_id
Index: trunk/ippTools/share/dettool_revertstacked.sql
===================================================================
--- trunk/ippTools/share/dettool_revertstacked.sql	(revision 28553)
+++ trunk/ippTools/share/dettool_revertstacked.sql	(revision 28558)
@@ -1,3 +1,8 @@
 DELETE FROM detStackedImfile
+USING detStackedImfile, detRun
 WHERE
     fault != 0
+AND
+    state = 'run'
+AND
+    detStackedImfile.det_id = detRun.det_id