Apparently, Ignition decided that I need “UPDATE Query” enabled on all UI fields that use an SQL binding (I’ve seen it on text fields, dropdown lists and checkboxes).
Whenever I add a new GUI item, and define a query binding to some parameter, the “UPDATE Query” is enabled by default (this used to be disabled by default). However, it can be seemingly disabled in the designer. But whatever you do, it will spit errors in the client because the query isn’t valid. And the next time you open the designer, everything is enabled again.
Has someone else seen this? We’re using version 7.9.7, on an Ubuntu server on OpenJDK 1.8.0_162. This has happened on two servers with different projects, but an almost identical configuration.
The projects are upgraded from older 7.9 versions though, before the named queries appeared. Luckily, there’s no table with the name “tablename”, so all those queries just fail, and I can update the DB with one click on the “submit” button.