diff flys-aft/src/main/resources/sql/aft-common.properties @ 5480:7a68967ca72a

AFT/DIPS: Small fixes and workarounds for Oracle DB problems.
author Sascha L. Teichmann <teichmann@intevation.de>
date Wed, 27 Mar 2013 20:19:09 +0100
parents da1e897c7224
children
line wrap: on
line diff
--- a/flys-aft/src/main/resources/sql/aft-common.properties	Wed Mar 27 18:48:28 2013 +0100
+++ b/flys-aft/src/main/resources/sql/aft-common.properties	Wed Mar 27 20:19:09 2013 +0100
@@ -17,9 +17,9 @@
     SELECT TAFELWERT_NR AS id, WASSERSTAND AS w, ABFLUSS AS q FROM TAFELWERT \
     WHERE ABFLUSSTAFEL_NR = :number
 select.bfg.id.current = \
-    SELECT BFG_ID AS BFG_ID FROM ABFLUSSTAFEL \
+    SELECT ABT.BFG_ID AS BFG_ID FROM ABFLUSSTAFEL ABT \
     WHERE GUELTIG_VON IN ( \
         SELECT min(GUELTIG_VON) FROM ABFLUSSTAFEL \
         WHERE GUELTIG_VON IS NOT NULL AND GUELTIG_BIS IS NULL \
         AND MESSSTELLE_NR LIKE :number) \
-    AND MESSSTELLE_NR :number
+    AND MESSSTELLE_NR LIKE :number

http://dive4elements.wald.intevation.org