comment Posted March 11, 2005 Author Share Posted March 11, 2005 I am discovering that a Custom Function will not perform more than 10,000 recursions. Beyond that I get a question mark in the calc field. I can't find any documentation for this limitation. Can anyone confirm/disprove this? Link to comment Share on other sites More sharing options...
comment Posted March 11, 2005 Share Posted March 11, 2005 I am discovering that a Custom Function will not perform more than 10,000 recursions. Beyond that I get a question mark in the calc field. I can't find any documentation for this limitation. Can anyone confirm/disprove this? Link to comment Share on other sites More sharing options...
comment Posted March 11, 2005 Author Share Posted March 11, 2005 I am discovering that a Custom Function will not perform more than 10,000 recursions. Beyond that I get a question mark in the calc field. I can't find any documentation for this limitation. Can anyone confirm/disprove this? Link to comment Share on other sites More sharing options...
Fenton Posted March 11, 2005 Share Posted March 11, 2005 From the file "Recursive" by Andrew Parsons (excelisys.com): Link to comment Share on other sites More sharing options...
Fenton Posted March 11, 2005 Share Posted March 11, 2005 From the file "Recursive" by Andrew Parsons (excelisys.com): Link to comment Share on other sites More sharing options...
Fenton Posted March 11, 2005 Share Posted March 11, 2005 From the file "Recursive" by Andrew Parsons (excelisys.com): Link to comment Share on other sites More sharing options...
-Queue- Posted March 11, 2005 Share Posted March 11, 2005 I can confirm that this is the limit. Starting with a parameter of 1. Case( num = 10000; "end"; num & " - " & test(num + 1) ) works, but Case( num = 10001; "end"; num & " - " & test(num + 1) ) returns a question mark. Link to comment Share on other sites More sharing options...
-Queue- Posted March 11, 2005 Share Posted March 11, 2005 I can confirm that this is the limit. Starting with a parameter of 1. Case( num = 10000; "end"; num & " - " & test(num + 1) ) works, but Case( num = 10001; "end"; num & " - " & test(num + 1) ) returns a question mark. Link to comment Share on other sites More sharing options...
-Queue- Posted March 11, 2005 Share Posted March 11, 2005 I can confirm that this is the limit. Starting with a parameter of 1. Case( num = 10000; "end"; num & " - " & test(num + 1) ) works, but Case( num = 10001; "end"; num & " - " & test(num + 1) ) returns a question mark. Link to comment Share on other sites More sharing options...
comment Posted March 11, 2005 Author Share Posted March 11, 2005 Thanks for confirming, Fenton and JT. A recursive calculation must provide a mechanism to end the loop, or it will run for 10,000 iterations That's not very well put, is it? JT's calc clearly does provide such a mechanism (as does mine). It seems that the correct statement would be: A recursive calculation will run for 10,000 iterations, or until FileMaker runs out of memory, or when a condition to end the loop has been met - whichever of the three comes first. Link to comment Share on other sites More sharing options...
comment Posted March 11, 2005 Author Share Posted March 11, 2005 Thanks for confirming, Fenton and JT. A recursive calculation must provide a mechanism to end the loop, or it will run for 10,000 iterations That's not very well put, is it? JT's calc clearly does provide such a mechanism (as does mine). It seems that the correct statement would be: A recursive calculation will run for 10,000 iterations, or until FileMaker runs out of memory, or when a condition to end the loop has been met - whichever of the three comes first. Link to comment Share on other sites More sharing options...
comment Posted March 11, 2005 Author Share Posted March 11, 2005 Thanks for confirming, Fenton and JT. A recursive calculation must provide a mechanism to end the loop, or it will run for 10,000 iterations That's not very well put, is it? JT's calc clearly does provide such a mechanism (as does mine). It seems that the correct statement would be: A recursive calculation will run for 10,000 iterations, or until FileMaker runs out of memory, or when a condition to end the loop has been met - whichever of the three comes first. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7007 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now