The DDR Reports fields as variables when there are matching names
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.
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.
The problem is that the DDR doesn't produce the same result as the actual field, it declares the entire Let function to be :
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
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.