Sort Records by Field
I am quite sure this is a stupid question, but I have not been able to find an answer on the forum--What is the difference between the script step "Sort Records by Field" and the script step "Sort Records"?
Both can produce exactly the same results but there are also sorting options that are sorting options that are only possible in one or the other.
Sort Records allows you to sort on multiple fields in one sort and uses the same dialog box that you use when selecting Sort from the Records Menu.
Sort Records by field mimics the behavior you get when you right click a field and select Sort Ascending, Sort Descending or Sort by Value List. It is limited to sorting on a single field. But it also can be used to sort whatever field has the current focus. Another nice thing about this step is that you can SEE the sort options right in the script editor, you don't have to open up a dialog to see how the records are being sorted.
Both script steps are documented in FileMaker help.
Retrieving data ...