10 Replies Latest reply on Aug 2, 2015 7:02 PM by philmodjunk

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

    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.