AnsweredAssumed Answered

The DDR Reports fields as variables when there are matching names

Question asked by nickorr on Oct 27, 2010
Latest reply on Nov 30, 2010 by TSGal

Summary

The DDR Reports fields as variables when there are matching names

Product

FileMaker Pro

Version

11v2

Operating system version

Mac OS 10.6.5

Description of the issue

When you have a calculation field that declares and uses variables that have the same name as other fields, the DDR misreports the data types and doesn't report the field in use.

Steps to reproduce the problem

Create a new file and add a field called "NumField".  Then add a second calculation field.  Make the calculation :

Let ( NumField = NumField + 1 ; NumField )

Then run the DDR to see how the field is reported.

Expected result

The calc field considers the reference to NumField to be a reference to the field not the variable, and so changing the value of NumField in a record changes the value of the calculation.

Considering that is how the actual calc field behaves, the DDR should report the same information.

Actual result

The problem is that the DDR doesn't produce the same result as the actual field, it declares the entire Let function to be :

Chunk type="NoRef"

In other words, that there are no field or other references in the calculation at all.  This is inconsistent with the actual working of the field, and causes issues for referencing fields used.

Exact text of any error message(s) that appear

None

Configuration information

NA

Workaround

You need to use a name other than the field name for the variable, which is a simple workaround and makes the code more logical anyway.  However, it's still an issue with accuracy for those who have already done this.

Outcomes