Use system.db.runUpdateQuery with variable value counts

[Tim]

I think this post may help you.

Update with IN condition

Hi Andrea, By array, do you mean a Python list? This will be my assumption unless you tell me differently. I’d say the problem is that SQL doesn’t understand lists. Try converting the list into a string: system.db.runPrepUpdate("UPDATE TEST SET FL= 1 WHERE ID IN (?)", [str(y)[1:-1]], "dscada_main") Not that converting a list to string keeps the brackets, so the [1:-1] will remove them. [attachment=0]2016-05-17_8-14-43.png[/attachment]