3 Replies Latest reply on Mar 4, 2011 9:12 AM by philmodjunk

    using 'dot' in filename problem

    splaisan

      Summary

      using 'dot' in filename problem

      Product

      FileMaker Pro

      Version

      11.0v3

      Operating system version

      OSX.6.6

      Description of the issue

      I created a global variable $$keyexist which looks whether a field contains a given key
      $$keyexist defined by: PatternCount (ValueListItems ( Get ( FileName ) ; "key" ); "mykey¶"))

      This global behaved perfectly until I changed the database file name and include a . (dot) in the new name for versioning (My-Database_v4.fp7 became My-Database_v4.1.fp7)

      After this, the global did not contain any value anymore although the key exists in many records although 'Get ( FileName )' returned 'My-Database_v4.1' as expected
      My other ValueLists were also not accessible using ValueListItems ( Get ( FileName ) ; "&&&" ); "XXXX¶").

      I renamed my file to 'My-Database_v41.fp7' and it works now again for all ValueLists.

      Could this have to do with filemaker making a macOS mistake when using Get ( FileName )

      Thanks for support
      Stephane

      Steps to reproduce the problem

      * create a value list filled from a text field from the current file
      * create a global variable $$keyexist linked to the valuelist
      $$keyexist defined by: PatternCount (ValueListItems ( Get ( FileName ) ; "key" ); "mykey¶"))
      display in a dialog the value of the variable at runtime (will be >0)
      * exit and rename the database including a dot in the name
      * open and display value again (=> 0 for me)

      Expected result

      >0

      Actual result

      0

      Exact text of any error message(s) that appear

      nope

      Configuration information

      latest everything installed

      Workaround

      remove the dot