4 Replies Latest reply on Jan 17, 2015 1:21 PM by JavierDura

    Getting a list of ids

    JavierDura

      Hi.

      I have a set of found records and I want to set a global variable with a List of all their ids. Something like:

       

      ACAB47A2-D856-DF4A-9D8F-BD55E3BF653A

      8813CE6C-6907-3C44-8E36-52DCE400502B

      693A527E-0148-3E41-BD93-8E14A323E257

      483313C6-B829-504C-AFF2-4F6B0CDFF0D1

       

      The solution is hosted by FileMaker Server 13.

       

      I am considering several approaches:

      1.- Using Execute SQL: first I should “mark” the found records so I can SELECT them.

      2.- Using a script: a loop that goes through the found set and takes the id of each record.

       

      Which one will run faster?

      Any other suggestions?

      Maybe a little bit of “Perform Script on Server”?

      As this variable will have hundreds of ids, I need to be as quick as possible.

       

      Thanks!