AnsweredAssumed Answered

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

Question asked by mtinder on Jul 6, 2012
Latest reply on May 12, 2015 by TSGal

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

Outcomes