7 Replies Latest reply on Apr 30, 2016 3:12 PM by beverly

    ExecutionSQL calculation

    GaoshengHuang

      I am preparing for FileMaker certification exam and came across a test prep question on the internet:

       

      What can be done with an ExecuteSQL calculation function?

      A. Count the number of unique values in a field from a set of related records.

      B. Populate a field in a set of related records with the result of a calculation function.

       

      The answer is A. But I don't see the difference between the two answers. Could somebody help?

       

      Thanks in advance!