Search the Community
Showing results for tags 'recursive'.
I have a question regarding how FM persists local variables ("$") across iterations of a script that's called recursively. Say you have a script "dosomething". And in this script there's a loop: set variable $counter=1 loop perform script dosomething exit loop if condition-is-met $counter=$counter+1 end loop Obviously this is pseudo code, but I hope you get the gist. My question is, say the first time the script calls itself. You have the original $counter, and the "new" $counter. Does the latter affect the former? That is, I know that "$" variables are loca
I think I'm constructing a Rube Goldberg-esque solution to my problem. Here's the application domain. I have a table of records that correspond to patent applications, which are commonly referred to as matters. A matter can claim (but does not have to) immediate priority to one and only one other matter. However, more than one matter can claim priority to the same matter, and a matter that has matter(s) which claim priority to it can itself claim priority to a matter. When a matter claims priority to another matter, this means that the former matter is of lower priority than the latter ma
I've been trying to write a Custom Function that will give me a list of unique combinations between two occurrences of the same list. The nearest I've come is with this Function, using the following list as an example 1,2,3,4 ListCombinations ( listofValues ; separator ) Let([ listLength = ValueCount(listOfValues); lastValue = GetValue(listOfValues; listLength); lesserList = Case( listLength > 1; ListCombinations(LeftValues(listOfValues; listLength -1 ); separator); "") ]; Case( listLength = 0; ""; listLength = 1; RightValues(listOfValues; 1); /* Ensures ¶ at end */ lastValue &a
Single Table Tree Structure Database. Every record has a unique ID and a parent ID. The Parent ID always matches some other records unique ID A Parent can have multiple Children. A child only has a single parent. The root record has a parent ID that matches it's own ID (or zero if you like) Given any ID I need to be able to search up through the tree to find the first parent record or parents parent record etc that has a character field = "Diamond". If not found I need to be able to return the root record. Given the same ID I need to be able to provide a list of all the