My name is Pawel and I am new to Ignition Software.
I am trying to create script to modify 1 cell in selected row (Status).
I have copied code from Ignition site, but it give me error.
It changed “scanned” value to “0.0” but then, error is displayed and old value comes back. The value is fixed and will be always the same. 0.0
GatewayException: SQL error for “UPDATE tablename
SET columnname = value
WHERE condition”: An expression of non-boolean type specified in a context where a condition is expected, near ‘condition’.
caused by SQLServerException: An expression of non-boolean type specified in a context where a condition is expected, near ‘condition’.
Ignition v7.9.8 (b2018060714)
Java: Oracle Corporation 1.8.0_181
I am trying to solve this problem for the whole day but can’t find working solution. I hope you can help me with this.
All your help is much appreciated.