There are three ways to set up the List function.
List ( RelatedTable::Field )
List ( repeatingField )
List ( Field1 ; Field2 ; field3... )
Am I correct that you used the last option?
It may be limit in calculation parser. Substitute() have 999 documented in help.
No error on
Evaluate("List(" & e & e & e & "2)")
Evaluate("List(" & e & e & e & "2;3)")
"too many parameters"
I'm setting up the list in a text editor. It looks like this.
I'm curious because I've worked with lists in large data sets and I don't remember bumping into this before.
1 of 1 people found this helpful
Resulted list can have more than 1000 values of course, but functions have limit on number of parameter.
It seems like it is a hard limit, at least for FMPv15
I put your two formulae into a script and added a ValueCount(). The first example returns a value of 1000, the second returns an value of 1. When I get the text of the second it returns "?".
user19752 is right. The limit is imposed on the number of parameters passed into the function, not on the number of items that the function can return.
If a related table contains thousands of records then list ( related::field ) may return thousands of items. However, the example is only using a single parameter.