Why Get ( CalculationRepetitionNumber ) doesn't work?

[Rafita]

I don't understand why it works only for the first repetition.

Any hint would be greatly appreciated.

Tnx.

[David Jondreau]

It's because idioma is not a repeating field. So when FM looks to idioma from the 2nd rep of the MenuTitulo field, it finds a null value for the 2nd rep for the idioma field. If you wrap each of your references to non-repeaters in an Extend() function, it should work as expected.

Of course, you've chosen to use repeating fields instead of the preferred relational design. But I'm not going to mention that. :)

Edited January 29, 2008 by Guest

[comment]

It doesn't work, because you are not using Extend() around non-repeating fields.

It can also be a lot simpler, because in a repeating calculation field you can reference other repeating fields directly, and get the corresponding repetition.

[Rafita]

Thanks, D J for the quick answer. I'm going to try it.

GBY

[Rafita]

Well, I thought it was a simple way, to update globals anytime you decide to change language (idioma), as this table will have only one record, and place those globals all around the solution.

[comment]

I wasn't talking about that. All I meant is you don't need all this GetRepetition() and Get ( CalculationRepetitionNumber ) stuff.

BTW, you might find this thread interesting:

http://www.fmforums.com/forum/showtopic.php?tid/183314/

[Rafita]

Ok, Dr. comment, I first studied/learned/enjoyed your LanguageLabels technique, then I applied it in a copy & paste basis to my solution. Thank you very much.

GBY