Having a simple named query like this:
INSERT INTO test_table (c1, c2, c3) VALUES (:c1_value, :c2_value, :c3_value) ON DUPLICATE KEY UPDATE c3 = :c3_value
Running this in the Testing window works as expected, however, when trying to bind this query as the UPDATE query with any of the parameters set to a CLIENT tag, this fails as the client tag value doesn’t seem to change in the query unless the window is closed and opened!
Forgot to mention, binding the client tag to e.g. a numeric text field then the query parameter to the text fields value property instead makes the query work as expected.