Hi all, Is there any smart service / functions we could use to execut

Hello Alvinc

Had you able to achieve this functionality? I am also working on similar POC where I need to execute multiple UPDATE statements on tables. I have the script in a process variable. While passing that variable to query database node, it is breaking. 

Please let me know if you have achieved this.

Thanks in advance.

Rahul Zanwar

Hi Rahul,

As I understand you need to execute multiple update statements 

on a single table - write the query in the setup tab of the smart service (Query database) and give custom AC variable (ac!id ) which should be same as the column used as a filter. Then you can provide PV variable for that particular ac created in inputs.

Hi Vinay,

Thanks for your response. 

My requirement is different. I have list of UPDATE statements in PV and the number of statements is not defined.

For example: 

UPDATE TableName SET columnName = 'value2' WHERE columnNAme = 'value1'

UPDATE TableName SET columnName = 'value4' WHERE columnNAme = 'value3'

UPDATE TableName2 SET columnName = 'value4' WHERE columnNAme = 'value3'

I have created a AC in setup tab of Query Database and configure it with the PV, but it is not working.

Hi Vinay,

Thanks for your response. 

My requirement is different. I have list of UPDATE statements in PV and the number of statements is not defined.

For example: 

UPDATE TableName SET columnName = 'value2' WHERE columnNAme = 'value1'

UPDATE TableName SET columnName = 'value4' WHERE columnNAme = 'value3'

UPDATE TableName2 SET columnName = 'value4' WHERE columnNAme = 'value3'

I have created a AC in setup tab of Query Database and configure it with the PV, but it is not working.