11 Replies Latest reply on May 12, 2015 6:40 AM by TSGal

    FieldType function returns null if filename contains a period "."

    mtinder

      Summary

      FieldType function returns null if filename contains a period "."

      Product

      FileMaker Pro

      Version

      12.0v1

      Operating system version

      Mac OS X 10.6.8

      Description of the issue

      When using the FieldType function, and the filename contains a period ".", the FieldType function returns nothing for the referenced field.

      Steps to reproduce the problem

      1) Create a new file named: ATest, resulting name: ATest.fmp12
      2) Create a new field named: MyField, Type of "Text"
      3) Enter in Data Viewer the following calculation:
          FieldType ( Get ( FileName ) ; "ATest::MyField" )

          It shows a result of:
          Standard Text Unindexed 1
      4) Close & rename the file to: ATest v1.0, resulting name: ATest v1.0.fmp12
      5) The FieldType function no longer returns the expected value.

      Expected result

      FieldType function returns: Standard Text Unindexed 1

      Actual result

      FieldType function returns: ""

      Workaround

      FieldType ( "" ; "ATest::MyField" )

      omitting the filename function for the first parameter