Mercurial > dive4elements > river
comparison flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/sq/MeasurementFactory.java @ 3922:e1d3f6bccf2b
S/Q: More symbols in reconstruction of Excel macros.
flys-artifacts/trunk@5606 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Thu, 27 Sep 2012 08:51:51 +0000 |
parents | 3bffbf670b49 |
children | d3e2080d3ada |
comparison
equal
deleted
inserted
replaced
3921:deff2c337111 | 3922:e1d3f6bccf2b |
---|---|
39 "RSIEB21", "REST" | 39 "RSIEB21", "REST" |
40 }; | 40 }; |
41 | 41 |
42 public static final String SQL_MEASSURE = | 42 public static final String SQL_MEASSURE = |
43 ("SELECT " + | 43 ("SELECT " + |
44 "m.TSAND AS TSAND," + | 44 "m.TSAND AS TSAND," + |
45 "m.TSCHWEB AS TSCHWEB," + | 45 "m.TSCHWEB AS TSCHWEB," + |
46 "m.CSCHWEB AS CSCHWEB," + | 46 "m.CSCHWEB AS CSCHWEB," + |
47 "m.Q_BPEGEL AS Q_BPEGEL " + | 47 "m.Q_BPEGEL AS Q_BPEGEL," + |
48 "m.TGESCHIEBE AS TGESCHIEBE " + | |
48 // ", %GSIEBSATZ% " + | 49 // ", %GSIEBSATZ% " + |
49 // "%SSIEBUNG% " + | 50 // "%SSIEBUNG% " + |
50 "FROM messung m " + | 51 "FROM messung m " + |
51 "JOIN station s ON m.stationid = s.stationid " + | 52 "JOIN station s ON m.stationid = s.stationid " + |
52 "JOIN gewaesser g ON s.gewaesserid = g.gewaesserid " + | 53 "JOIN gewaesser g ON s.gewaesserid = g.gewaesserid " + |