The DDR Reports fields as variables when there are matching names
Mac OS 10.6.5
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.
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.
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.
Thank you for your post, and I apologize for the late reply.
I have forwarded your entire post to our Development and Product Management departments for review and confirmation. I'll keep you posted as information becomes available to me.