I am trying for the first time to use ExecuteSQL. My attempt has caused a hang with the display "Records remaining to process". I created a new field in the table "Pricing". The field is a global field with this calculation: ExecuteSQL ( "SELECT DISTINCT \"_FacilityID_fk\" FROM \"Pricing\"" ; "" ; "" ). There are about 8800 records in that table. FileMaker does not show as non-responsive in Activity Monitor.
What did I do wrong and how do I resolve the hang?