Valuechanged type error 'str' object is not callable

Ignition
1

Hello,
I have a problem in the changed value of a tag. I put this script:

[i]import time
value_command = system.tag.read("[.]NEW_COMMAND")
value_command_1 = value_command.getValue()

query = (“UPDATE scd_command SET id_command_status = 1 WHERE cd_command = %i”)
system.db.runUpdateQuery(query % (value_command_1))

value = system.tag.read("[.]HEADER")
value_1 = value.getValue()
system.tag.write("[.]FOOTER", value_1)
time.sleep(1)
system.tag.write("[.]WRITE_FOOTER",0)[/i]

But it gives me this error:
Valuechanged type error ‘str’ object is not callable

I tried the script playground and I do not return this error.
Can you help to solve?

Thanks

Untitled.png1160×698 46.4 KB

2

Try this instead:

query = "UPDATE scd_command SET id_command_status = 1 WHERE cd_command = %i" % value_command_1 system.db.runUpdateQuery(query)