Using an ORDER BY Clause in Custom SQL Script for SmartFill


Provides information on using an ORDER BY clause in a custom SQL script for SmartFill.


You can add an ORDER BY clause to your custom SQL script. However, it won’t have any effect on the order in which the results are displayed in the Select Record window.

The purpose of the stored procedure is to insert records into the SF001 table.  This table is used to display the results in the Select Record window.  The order the results are initially displayed will always be by the first column listed.