AnsweredAssumed Answered

using 'dot' in filename problem

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

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

Outcomes