6 Replies Latest reply on Jun 15, 2012 10:37 AM by ch0c0halic

    Can ExecuteSql retrieve values from a filemaker found count

    KevinMortimer

      I am trying to get an executeSQL to return a list of found ids...but it seems to ignore filemaker found count and return all ids in table. I have tried following but both ignore the found count and return results based on all records in the table. Is there a way to tell SQL to just calculate the records in the filemaker found set?

       

      "SELECT id FROM TABLE products"

      "SELECT id FROM TABLE products WHERE recordNumber between 1 and 20"