I need to sort a column in my report for ascending and descending order. Using FileMaker's standard sort gives a progress bar and client is tired of waiting for the sort to finish. I am looking to using ExecuteSQL to sort for hopefully a faster result. I have my execute sql statement of:
ExecuteSQL ( "SELECT city FROM client ORDER BY city DESC"; ""; "" ) but I not certain how to execute this command to sort my city field as a script step.
I have tried using the script stop of Execute SQL but it fails every single time with no feedback as to what could be wrong. I would appreciate any help about this because I don't understand this.