Changeset 20734 for trunk/ippTools/share/magictool_definebyquery_temp_insert.sql

Timestamp:

Nov 13, 2008, 2:56:00 PM (17 years ago)

Author:

Paul Price

Message:

Cleaning up magictool -definebyquery so that part1 and part2 queries aren't required (psDBRunQuery takes %s etc). Adding '-available' flag which says 'don't worry if all the diffs didn't make it, just do it with whatever's immediately available.'

File:

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

trunk/ippTools/share/magictool_definebyquery_temp_insert.sql

@@ -21 +21 @@
 WHERE
     diffSkyfile.fault = 0
+---- WHERE hook %s
+GROUP BY
+    exp_id,
+    warpSkyfile.skycell_id