T
twc
Guest
Progress 10.1C and 10.2B How does one dynamically access index keys of a TEMP-TABLE? Use Case: Dataset created with no direct DB table relation (i.e. no "like" DB table to access _file, _field, _index to process) Utility processing implemented dynamically - pass any dataset handle with any structure, all character fields are processed and SOME CAN BE changed using tracking-changes and BEFORE-TABLES Utility provides reporting support - any dataset handle received will have changes reported based upon BEFORE-TABLES report data changed by: find unique index with fewest components (fields) - if no unique key, use primary index ( how to do this??? ) print index field name/values (i.e. allow user to uniquely identify source data) for fields changed, display field name and before/after values Can't find anything about dynamic TEMP-TABLE index access with the one exception - "
rimary" displays the name (character value) of the primary index. The name doesn't help determine which fields are components of the primary index. What about other indexes? Seems like this has to be available and I am just missing it. Thanks, Tim
Continue reading...
rimary" displays the name (character value) of the primary index. The name doesn't help determine which fields are components of the primary index. What about other indexes? Seems like this has to be available and I am just missing it. Thanks, TimContinue reading...