AnsweredAssumed Answered

Erattic behaviour of GetFieldName ( field )

Question asked by PeterWagemans on Jun 11, 2015
Latest reply on Jun 11, 2015 by Fred(CH)

Summary

Erattic behaviour of GetFieldName ( field )

Product

FileMaker Pro

Version

11, 12, 13, 14

Operating system version

OSX, Windows

Description of the issue

GetFieldName ( field ) also evaluates the field being referred to, while it should only get the field's name.

Steps to reproduce the problem

1. Open lab scale file https://dl.dropboxusercontent.com/u/18762341/GetFieldNameBug.fmp7
2. examine erratic result
3. convert to fmp12 format
4. open file

Expected result

"abc" in both the .fmp7 file and the .fmp12 file.

Actual result

hang crash in .fmp12 file, "abc" and empty in .fmp7 file.

Exact text of any error message(s) that appear

none

Workaround

None.

Notes:
1. FileMaker versions > 11 try to evaluate the fieldcontents as well but crash because they get stuck in a circular calculation ( the calc field is the key to the related field being evaluated ).
2. GetFieldName() is an essential helper function to soft code the SQL statement in an ExecuteSQL function.

Outcomes