I'm building application that needs to get the Dynamic Update action.
Basically I have a field in the data table called "REVIEW_STATUS" and I want to use dynamic update action (via action button) to update this field on selected records to say "Reviewed". (By default the field says UnReviewed).
I can use the dynamic update like this
UPDATE Table SET Review_Status = 'Reviewed' WHERE Country='UK';
..... but I don't want it to say " WHERE Country='UK'..... I want it to say something like
UPDATE Table SET Review_Status = 'Reviewed' on currently selected records
Any ideas what the syntax is for the "on currently selected records" bit??
