Matt Navarre January 9, 2012 at 4:04 pm #

I do love a tricky challenge with FileMaker Search.

Usually what I would do with a problem like this is do a simple search, like the ‘A’ method outlined above, and then do a loop script to test all the matching records to see if they exactly match the original search. Since the found set will be very small, the loop is very fast. And even if you have several million records in the found set, you can test for that before doing the loop so the user never sees a delay.

This was taken from filemakerhacks.com website as i just did not understand what Matt was saying. Can someone please tell me what exactly he is saying here?

My question is, Where do you do the loop

set var : $searchString : value: test::note;

Enter Find Mode

set field : test::note $searchString;

perform find []

Here is attached link to article: http://www.filemakerhacks.com/?p=3501

-ian

after the "perform find[]", as you mentioned, you would do a loop like this...

Loop

    If[$searchString = test::note]

        go to next record[ exit after last ]

    Else

        omit record

    End If

End Loop

Nice one danSmith65. Thank you

-i