AnsweredAssumed Answered

Execute SQL first time

Question asked by SteveKeiser on Jan 31, 2019
Latest reply on Feb 1, 2019 by beverly

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?

Outcomes