I have found that if a key column is deleted and then recreated using the Eclipse Profile tool (to rename the field, for instance), the key's column name is returned as "TMP" in all subsequent result sets. The problem is caused when the "sub field definition" attribute of the key column contains "~~~". Clearing this field [set $piece(^DBTBL("SYSDEV",1,TABLENAME,9,KEYNAME),"|",18)=""] appears to fix it.
Ed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have found that if a key column is deleted and then recreated using the Eclipse Profile tool (to rename the field, for instance), the key's column name is returned as "TMP" in all subsequent result sets. The problem is caused when the "sub field definition" attribute of the key column contains "~~~". Clearing this field [set $piece(^DBTBL("SYSDEV",1,TABLENAME,9,KEYNAME),"|",18)=""] appears to fix it.
Ed
This issue has been fixed and will be included in the next release.