Hi,
I need to use a Query Database to update a column in multiple rows in a database table based on the IDs. The IDs are stored in a pv of text type.
For example -
pv has IDs- 14567, 14789
So the 'updatecolumn' column needs to be updated with 0 for both IDs.
TIA!
Discussion posts and replies are publicly visible
Any reason you can't use the Write to Datastore smart service? (either in a process, or the a!writeToDatastore() function in a SAIL form)? This will update the relevant rows in the database if you provide the relevant key values...