AnsweredAssumed Answered

using 'dot' in filename problem

Question asked by splaisan on Mar 3, 2011
Latest reply on Mar 4, 2011 by philmodjunk


using 'dot' in filename problem


FileMaker Pro



Operating system version


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

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


Actual result


Exact text of any error message(s) that appear


Configuration information

latest everything installed


remove the dot