2 Replies Latest reply on Aug 16, 2012 8:45 AM by pmconaway

    Is there a limit on Scripted find requests

    pmconaway

      I'm considering scripting a series of find requests.

      Enter Find Mode
      New Record/Request
      Set field[x] = value a
      New Record/Request
      Set field[x] = value b
      ...
      Perform Find
      

      My question is how many request can I have before Filemaker has a problem. What I am considering doing is performing an executeSQL statement to create a list of values to insert into my finds. The list has the protential to to being hugh. So I could possibly have 1000s of find requests before I get to the "Perform Find" script step.

       

      What I am looking to do is automate culling out bad records in the database.

       

      Paul