Mercurial > dive4elements > river
annotate flys-aft/src/main/resources/sql/aft-oracle-jdbc-oracledriver.properties @ 4173:7d4480c0e68e
Allow users to select the current relevant discharge table in historical discharge table calculattion.
In addition to this, the discharge tables in the helper panel displayed in the client is ordered in time.
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Thu, 18 Oct 2012 12:13:48 +0200 |
| parents | 9ba12119e662 |
| children | d9f1202cef78 |
| rev | line source |
|---|---|
|
4106
9ba12119e662
Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
1 select.abflusstafel = SELECT ABFLUSSTAFEL_NR, \ |
|
9ba12119e662
Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
2 ABFLUSSTAFEL_BEZ, \ |
|
9ba12119e662
Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
3 GUELTIG_VON, \ |
|
9ba12119e662
Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
4 GUELTIG_BIS, \ |
|
9ba12119e662
Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
5 PEGELNULLPUNKT FROM ABFLUSSTAFEL WHERE MESSSTELLE_NR LIKE :number |
|
9ba12119e662
Added SQL statements to make the connection to the AFT database Oracle compatible.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff
changeset
|
6 |