October 22, 200421 yr Hi, Here's attached a FM5 and a FM7 file. I'm using this tip to parse out a category from a multiline field (through a script for real). As there may be multiple matches, I'm locating the longer one with this technique. The Last( ) function isn't returning the correct result with 7 right now, or may be I am missing something. If all fields are indexed, then it works though.
October 22, 200421 yr It's not quite like you to forget to post the attachment. Maybe it's time for a nap?
October 22, 200421 yr Author Oops Here back the 3 files. The v7 Index works, the other involving a global doesn't. Note that the category field isn't a global though, which in the real life and v5 is the case. But this doesn't make any difference. FM7RepeatBug.zip
October 23, 200421 yr I remember this being a problem before. Last doesn't seem to evaluate unstored repetition calculations. Poot.
October 24, 200421 yr What is it that you say isn't working? They all seem to work for me. At least, if I pick item 2 in the value list I see the repeats for item 2. Same for item 1 or 3. But I must be missing something, what's the problem?
October 25, 200421 yr Author Hi Bruce, It's the "correct category" field, which should return the longest match. In v5, Last( ) would return this value, either if the repeating field is stored or not. With v7, if the repeating field isn't indexed, Last( ) is empty. As Max( ) works, the workaround, at the moment, is to change the filterMatch so that you can use GetRepetition( ) then.
Create an account or sign in to comment