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"