RobertWard

Executing - Execute SQL

Discussion created by RobertWard on Sep 26, 2016
Latest reply on Sep 27, 2016 by user19752

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.

Outcomes