Changeset 14033 for trunk/ippTools/src/dettool.c

Timestamp:

Jul 5, 2007, 4:46:53 PM (19 years ago)

Author:

jhoblitt

Message:

fix dettool -raw SQL

File:

• trunk/ippTools/src/dettool.c (modified) (1 diff)

trunk/ippTools/src/dettool.c

@@ -2050 +2050 @@
     PS_ASSERT_PTR_NON_NULL(config, false);
 
-    psString query = psStringCopy(
-            "SELECT"
-            "   detInputExp.det_id,"
-            "   detRun.det_type,"
-            "   rawImfile.*,"
-            "   rawExp.camera"
-            " FROM rawImfile"
-            " JOIN detInputExp"
-            "   USING(exp_id) "
-            " JOIN rawExp"
-            "   USING(exp_id) "
-            " JOIN detRun"
-            "   ON detInputExp.det_id = detRun.det_id"
-            " WHERE"
-            "   detRun.state = 'run'"
-            "   AND detRun.mode = 'master'"
-        );
+    psString query = pxDataGet("dettool_raw.sql");
+    if (!query) {
+        psError(PXTOOLS_ERR_DATA, false, "failed to retreive SQL statement");
+        return false;
+    }
 
     if (config->where) {