Erattic behaviour of GetFieldName ( field )
11, 12, 13, 14
Operating system version
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
"abc" in both the .fmp7 file and the .fmp12 file.
hang crash in .fmp12 file, "abc" and empty in .fmp7 file.
Exact text of any error message(s) that appear
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.