AnsweredAssumed Answered

ValueListItems() fails if there is a period in the filename

Question asked by lyle on May 5, 2015
Latest reply on Oct 9, 2017 by lyle

Summary

ValueListItems() fails if there is a period in the filename

Product

FileMaker Pro

Version

13.0v5

Operating system version

Windows or Mac OS X

Description of the issue

The ValueListItems(), when it works correctly, returns a list of values from a value list whose name is passed to it, from the file whose name is also passed to it. So, this function call should return the values from the list "BatchList" in the current file:

ValueListItems(Get(FileName);"BatchList")

It does so if, for example, the current file is named "Widget Database 1-1.fmp12, but returns an empty list if the current file is named "Widget Database 1.1.fmp12"

Steps to reproduce the problem

Just select a database which includes a value list. Write a one-step script that creates a custom dialog to show the results of the above function call. Make a copy of the database, and include a period in the new copy's name. The script in the copy will return an empty list.

A trivial example file that demonstrates the issue is at:

http://www.dogsbreakfast.net/Fido/Widget%20Database%201-1.fmp12

Expected result

List of values, e.g.,
1001
1002
1003
...

Exact text of any error message(s) that appear

None

Workaround

Rename the file.

Outcomes