Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 5479:11fba4dabe05 | 5480:7a68967ca72a |
|---|---|
| 15 WHERE MESSSTELLE_NR LIKE :number | 15 WHERE MESSSTELLE_NR LIKE :number |
| 16 select.tafelwert = \ | 16 select.tafelwert = \ |
| 17 SELECT TAFELWERT_NR AS id, WASSERSTAND AS w, ABFLUSS AS q FROM TAFELWERT \ | 17 SELECT TAFELWERT_NR AS id, WASSERSTAND AS w, ABFLUSS AS q FROM TAFELWERT \ |
| 18 WHERE ABFLUSSTAFEL_NR = :number | 18 WHERE ABFLUSSTAFEL_NR = :number |
| 19 select.bfg.id.current = \ | 19 select.bfg.id.current = \ |
| 20 SELECT BFG_ID AS BFG_ID FROM ABFLUSSTAFEL \ | 20 SELECT ABT.BFG_ID AS BFG_ID FROM ABFLUSSTAFEL ABT \ |
| 21 WHERE GUELTIG_VON IN ( \ | 21 WHERE GUELTIG_VON IN ( \ |
| 22 SELECT min(GUELTIG_VON) FROM ABFLUSSTAFEL \ | 22 SELECT min(GUELTIG_VON) FROM ABFLUSSTAFEL \ |
| 23 WHERE GUELTIG_VON IS NOT NULL AND GUELTIG_BIS IS NULL \ | 23 WHERE GUELTIG_VON IS NOT NULL AND GUELTIG_BIS IS NULL \ |
| 24 AND MESSSTELLE_NR LIKE :number) \ | 24 AND MESSSTELLE_NR LIKE :number) \ |
| 25 AND MESSSTELLE_NR :number | 25 AND MESSSTELLE_NR LIKE :number |