ExecutionSQL calculation

Discussion created by GaoshengHuang on Apr 29, 2016
Latest reply on Apr 30, 2016 by beverly

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!