Changeset 26857 for branches/eam_branches/20091201/ippTools/share/chiptool_change_exp_state.sql

Timestamp:

Feb 10, 2010, 3:52:15 PM (16 years ago)

Author:

eugene

Message:

various updates from trunk (mostly magic state handling, dqstats)

File:

• branches/eam_branches/20091201/ippTools/share/chiptool_change_exp_state.sql (modified) (1 diff)

branches/eam_branches/20091201/ippTools/share/chiptool_change_exp_state.sql

@@ -4 +4 @@
 -- the chipProcessedImfile sub query
 UPDATE chipRun
-    SET state = '%s'
+JOIN rawExp using(exp_id)
+    SET chipRun.state = '%s'
+    -- set magicked hook %s
     WHERE
     chipRun.chip_id = %lld