I’m trying to combine a couple of inputs using SQLTags. It’s the classic 2 signals (open and close) for a valve, from which I want to derive the value position.
For testing, I created 2 points named Input_1 and Input_2 as Boolean SQLTag DB points with Read/Write access. I then created another Int1 point (Valve_Position) with the following Expression:
From the documentation this should treat each input as bits in a binary number and return the decimal equivalent as an integer with a range of 0-3, depending on what the individual bits are set to.
However when I change the values of Input_1 and Input_2, the value of Valve_Position stays resolutely at zero. Am I doing something wrong?