I have a set of found records and I want to set a global variable with a List of all their ids. Something like:
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.