1 Reply Latest reply on Nov 30, 2010 1:00 PM by TSGal

    The DDR Reports fields as variables when there are matching names

    nickorr

      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.