AnsweredAssumed Answered

"Parse Error." when using ExecuteSQL  or Evaluate() with GetFieldName() in a field calculation

Question asked by ToddGeist on Nov 27, 2012
Latest reply on May 12, 2015 by alecgregory

Summary

"Parse Error." when using ExecuteSQL  or Evaluate() with GetFieldName() in a field calculation

Product

FileMaker Pro

Version

12.0v3

Operating system version

mountain lion

Description of the issue

You can't use GetFieldName() in a Let Function with either Evaluate or ExecuteSQL, when defining a field calculation.

Steps to reproduce the problem

Try this in  Calculation Field.  Make sure the field you  are referencing with GetFieldName is unrelated.


Let([
s = GetFieldName(    )
];

Evaluate(s)


)

Expected result

the calculation dialog can be closed and the calculation field will work correctly

Actual result

You are not able to close the Calc Dialog.  You get "Parse Error." Instead.

Exact text of any error message(s) that appear

Parse Error.

Workaround

Getting rid of the LET function and doing this for example

Evaluate(GetFieldName(   ))

Works

Screenshot_11%3A27%3A12_12%3A24_PM.png

Outcomes