The end result can be exactly the same. I prefer Enter Find Mode, Set field, Perform find for two reasons:
- I can use calculations in the set field steps to produce the needed find criteria.
- I can SEE the criteria right there in the script editor. I don't have to open another window just to see what criteria are being used in the find.
Quick finds are different in two key ways:
1) the criteria is applied to multiple fields in your current layout, finding a record if any of the fields contain matching data.
2) If no records are found, you do not get a found set of zero records.
Thanks for the response. I have a follow up:
I understand in Set Field to do something like Set Field [TABLE::Variable;1] but I am unclear on trying to do this:
Set a field that is a calculation (for example a sum) that is not equal to 0 - so Set Field [SOMETABLE::c_SumOfSomething; <>0] - I know this syntax is wrong but I'm trying to show what I'm trying to do...
Thanks! In the calculation box I was putting =0 and not ==0!
But it's the omit records step that is key. The extra = might not be necessary.