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 " +

http://dive4elements.wald.intevation.org