ExecuteSQL and found set (using the IN part of the WHERE clause)

Discussion created by beverly Expert on Sep 21, 2015
Latest reply on Sep 21, 2015 by jbrown

Kevin Frank has posted another blog on


Found Set Awareness Revisited | FileMakerHacks


For ExecuteSQL newbies, there are MANY articles on ExecuteSQL on this site. ExecuteSQL | FileMakerHacks


Specifically these are a first step to learn (get the PDF and example files, the actual blog is "phase one"!):


The Missing FM 12 ExecuteSQL Reference | FileMakerHacks

in Japanese, the link to that PDF is here:

The Missing FileMaker 12 ExecuteSQL Referenceの日本語訳 | Not Only FileMaker


Only a few changes in FM13 & 14 (the new clauses for FIRST and OFFSET), are noted here:

FileMaker SQL Archives - SeedCode


For writing the SQL, the listed resources have at least two 'template' databases that help you get the syntax more correct.