I have a doubt on FINDSET(FALSE,FALSE).
Does FINDSET() = FINDSET(FALSE,FALSE) if so then can we use FINDSET(FALSE,FALSE) instead of FINDSET()? is there any performance issue?
Yes, FINDSET() = FINDSET(FALSE,FALSE) - so you can use either. It doesn't matter for performance, as they do the same.
Every time you use the FindSet command, you have to ask yourself two questions: 1) am I going to make a change to any of these records? 2) is any of the fields that I am changing part of the sort order?. You set the FindSet parameters according to the answers to those questions. Teach yourself to ALWAYS set the parameter values. Not just for yourself to force yourself to always THINK about this, but also for the person that has to maintain your code, so THEY know what your intention was.
Thanks Daniel for this wonderful suggestion.