update CustomList() on fileMaker Server ( Limited Evaluate )

[Agnès]

Hello,

I would like answer to this topic :

CustomList custom function limited to 300 items in list on FileMaker Server

Be careful when using the CustomList custom function on FileMaker server. My testing has revealed that the list this function will generate is limited to 300 entries when used on FileMaker Server. The documentation of this functions states that it is limited to 500,000 on FileMaker Pro and 150,000 on FileMaker Go.

I had never actually tested on server.

I just read this article by chance, I just did the test and saw that the function Evaluate () is the problem ( the same for FileMaker Go )

it is the current limit of FileMaker Serveur internal Evaluate function

FileMaker GO Evaluate () is limited to 400 (+/-)

FMServeur Evaluate () is limited to 300 (test FMServeur v11 )

instead of 1700 (+/-) for FileMaker. ( runtime and IWP )

I update the calc CustomList for this to work correctly on FMSserver

( http://www.briandunning.com/cf/868 and http://www.fmfunctions.com/fid/118 )

Do not hesitate to let me know by email if you have a problem with CustomList ()

In this case, I have made test with FMS v11, maybe the limit is different with other versions.

Thank you

Agnès