Changeset 29441 for branches/haf_branches/ipp.rsync.20101015/ippTools/share/minidvodbtool_revertminidvodbcopy.sql

Timestamp:

Oct 15, 2010, 7:31:09 PM (16 years ago)

Author:

heather

Message:

minidvodbtool now works

File:

• branches/haf_branches/ipp.rsync.20101015/ippTools/share/minidvodbtool_revertminidvodbcopy.sql (modified) (1 diff)

branches/haf_branches/ipp.rsync.20101015/ippTools/share/minidvodbtool_revertminidvodbcopy.sql

@@ -1 @@
-DELETE minidvodbCopy
-    SET state = 'new',
-    SET fault = 0
+UPDATE minidvodbCopy
+ --   SET minidvodbCopy.state = 'new',
+    SET minidvodbCopy.fault = 0
 WHERE
     minidvodbCopy.state = 'new'
     AND minidvodbCopy.fault >0    
-AND addRun.state = 'new'
+