Can ExecuteSql retrieve values from a filemaker found count

Discussion created by KevinMortimer on Jun 15, 2012
Latest reply on Jun 15, 2012 by ch0c0halic

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"