2 Replies Latest reply on Sep 21, 2015 5:32 AM by jbrown

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

    beverly

      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.

      beverly