Changeset 28611

Timestamp:

Jul 6, 2010, 9:51:00 AM (16 years ago)

Author:

bills

Message:

Prevent deletion of chipProcessedImfiles whose runs are not in state new by
correcting the sql

File:

• trunk/ippTools/share/chiptool_revertprocessedimfile.sql (modified) (1 diff)

trunk/ippTools/share/chiptool_revertprocessedimfile.sql

@@ -2 +2 @@
 USING chipProcessedImfile, chipRun, rawExp
 WHERE
-    rawExp.exp_id = chipProcessedImfile.exp_id
+    chipRun.chip_id = chipProcessedImfile.chip_id
+    AND rawExp.exp_id = chipProcessedImfile.exp_id
     AND chipRun.state = 'new'
     AND chipProcessedImfile.fault != 0