nach dem zusammenfügen meiner alten Datenbänke, DB versionsupdate und anschließendem Historian Update auf Version 3.3.0 will ich nun einzelne Datenpunke in der Web-Bedienschnitstelle ändern. Bisher tat ich das z.B. mit:
Code: Alles auswählen
UPDATE D_SYSVAR_40453_VALUE
SET VALUE = 463465.1867
WHERE TS = '2016-02-17 02:01:51'
Code: Alles auswählen
UPDATE D_SYSVAR_40453_VALUE
SET VALUE = 463465.1867
WHERE TS = '2016-02-17 02:01:51';
Syntax Fehler in SQL Befehl "UPDATE D_SYSVAR_40453_VALUE \000d\000aSET [*]VALUE = 463465.1867 \000d\000aWHERE TS = '2016-02-17 02:01:51'"; erwartet "identifier"
Syntax error in SQL statement "UPDATE D_SYSVAR_40453_VALUE \000d\000aSET [*]VALUE = 463465.1867 \000d\000aWHERE TS = '2016-02-17 02:01:51'"; expected "identifier"; SQL statement:
UPDATE D_SYSVAR_40453_VALUE
SET VALUE = 463465.1867
WHERE TS = '2016-02-17 02:01:51' [42001-214] 42001/42001 (Help)
org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax Fehler in SQL Befehl "UPDATE D_SYSVAR_40453_VALUE \000d\000aSET [*]VALUE = 463465.1867 \000d\000aWHERE TS = '2016-02-17 02:01:51'"; erwartet "identifier"
Syntax error in SQL statement "UPDATE D_SYSVAR_40453_VALUE \000d\000aSET [*]VALUE = 463465.1867 \000d\000aWHERE TS = '2016-02-17 02:01:51'"; expected "identifier"; SQL statement:
UPDATE D_SYSVAR_40453_VALUE
SET VALUE = 463465.1867
WHERE TS = '2016-02-17 02:01:51' [42001-214]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:502)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
at org.h2.message.DbException.getSyntaxError(DbException.java:261)
at org.h2.command.Parser.readIdentifier(Parser.java:5656)
at org.h2.command.Parser.readTableColumn(Parser.java:1080)
at org.h2.command.Parser.readUpdateSetClause(Parser.java:1151)
at org.h2.command.Parser.parseUpdate(Parser.java:1120)
at org.h2.command.Parser.parsePrepared(Parser.java:858)
at org.h2.command.Parser.parse(Parser.java:689)
at org.h2.command.Parser.parse(Parser.java:661)
at org.h2.command.Parser.prepareCommand(Parser.java:569)
at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:631)
at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:554)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:237)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:223)
at org.h2.server.web.WebApp.getResult(WebApp.java:1339)
at org.h2.server.web.WebApp.query(WebApp.java:1137)
at org.h2.server.web.WebApp$1.next(WebApp.java:1103)
at org.h2.server.web.WebApp$1.next(WebApp.java:1090)
at org.h2.server.web.WebThread.process(WebThread.java:188)
at org.h2.server.web.WebThread.run(WebThread.java:101)
at java.lang.Thread.run(Thread.java:748)
Mache ich was falsch oder gibt es da durch den Historian Versions Upgrade Änderungen die ich beachten muss?
Danke und Gruß,
Bengel00