Mercurial > dive4elements > river
diff flys-aft/src/main/resources/sql/aft-common.properties @ 4091:a91c7e982c32
Make W/Q values from AFT and FLYS loadable.
flys-aft/trunk@3601 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Thu, 05 Jan 2012 16:41:26 +0000 |
| parents | d556e29592f5 |
| children | 04377ccef10a |
line wrap: on
line diff
--- a/flys-aft/src/main/resources/sql/aft-common.properties Wed Jan 04 17:59:26 2012 +0000 +++ b/flys-aft/src/main/resources/sql/aft-common.properties Thu Jan 05 16:41:26 2012 +0000 @@ -5,4 +5,6 @@ strftime('%s', GUELTIG_VON) * 1000 AS GUELTIG_VON, \ strftime('%s', GUELTIG_BIS) * 1000 AS GUELTIG_BIS, \ PEGELNULLPUNKT FROM ABFLUSSTAFEL WHERE MESSSTELLE_NR LIKE :number +select.tafelwert = SELECT TAFELWERT_NR AS id, WASSERSTAND AS w, ABFLUSS AS q FROM TAFELWERT \ + WHERE ABFLUSSTAFEL_NR = :number