1 of 1 people found this helpful
You can't use the executeSQL function to set records.
To 'Populate a field in a set of related records...' you would use the Set Field script step.
The executeSQL calculation function only Returns information.
ExecuteSQL returns a list of values, and whatever your found set is, you are always sitting on a specific record.
In order to do B), you need to use a replace with - eventually - the results of the SQL, replace will work on the found set. ESql does not populate, it only retrieves a value. Which is what A) does.
The word "related", in both A) and B) is useless and misleading.
Already answered, and I feel this is bad question. (But of course this can become my bad English skill...)
A) ExecuteSQL() itself can't do anything about related records, need to contain relational info into SQL query. (Or, the "related records" is not used as FM term. This is worse in FileMaker certification)
B) "can be done with an ExecuteSQL" used in Set Field or some scripts.
Is this question testing only that user know "No function can populate field" ? So the best to do is read only 1st word in selections, all followings are there for misleading.
Unstored calculation field is effected with relation, so I should rethought about A.... But this is far from standard SQL.
I thought it was a bad question, too. I wouldn't rely on the "study guide" that asked it.
B. sounds like a trick question.
Unfortunately, for whatever reason, FIleMkaer only includes "Select" in the ExecuteSQL function.
But, happily, FileMaker includes the SELECT, UPDATE, INSERT, and DELETE using either a plug-in or using JDBC externally.
HOPE THIS HELPS.
Thanks to Jerry and to everybody else! I think Jerry's answer should work. By the way, is there a good book, website, etc that can help prepare the exam? I don't even know what the questions will be like.
Start here <http://www.filemaker.com/learning/developer-careers/certification/steps.html> and follow all the links.
The "overview" is here (PDF - the last link in step 3):
and read the FAQs: