Secsort is a parameter of the Join command that enables the secondary table data to be pre-sorted on the selected secondary key field(s) prior to processing a Join command. Secsort is offered as a checkbox in the Join command dialog.
Note: You cannot use the secsort command parameter within a Group command in a procedure.
For example, the following command syntax causes the output for the Join command to be presorted on the secondary key “No” prior to processing the command:
JOIN PKEY No FIELDS ALL SKEY No WITH ALL TO "Ar_Customer_Join" OPEN PRESORT SECSORT
In the Join command dialog, the Secsort command parameter is labelled “Presort” under the list of secondary key fields. Select the secondary key fields and then select the related “Presort” check box.