Changeset 17216 for trunk/ippTools/share/camtool_reset_faulted_runs.sql

Timestamp:

Mar 28, 2008, 3:57:39 PM (18 years ago)

Author:

jhoblitt

Message:

add camtool -revertprocessedexp query support

File:

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

trunk/ippTools/share/camtool_reset_faulted_runs.sql

@@ -1 @@
-UPDATE camRun, camProcessedExp SET camRun.state = 'run'
+UPDATE camRun, camProcessedExp, chipRun, rawExp
+SET camRun.state = 'run'
 WHERE
     camRun.cam_id = camProcessedExp.cam_id
+    AND camRun.chip_id = chipRun.chip_id
+    AND chipRun.exp_id = rawExp.exp_id
     AND camProcessedExp.fault != 0