Hi All, anyone have experience on update multiple row on data store using Query

heriz over 10 years ago

Hi All, anyone have experience on update multiple row on data store using Query Database smart service?
Below is my SQL Statement :
UPDATE `Appian`.`einregcustomer` SET `flagadd` = '1' WHERE `einregcustomer`.`idcust` in (ac!cust)

ac!cust contain multiple value like 8,9,10 where user selected in paging grid on previous user input task.
With statement above, only the first row success updated. The next rows not updated.
Thanks before for your kindly response.

...

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 10 years ago

When configuring this node click on the Data tab and make sure the ac!cust has the "Multiple" checkbox enabled.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 10 years ago

When configuring this node click on the Data tab and make sure the ac!cust has the "Multiple" checkbox enabled.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data