Kbase P114856: TEMP-TABLE records are not available inside a FOR EACH.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/04/2009 |
|
Status: Unverified
SYMPTOM(s):
TEMP-TABLE records are not AVAILABLE inside a FOR EACH.
TEMP-TABLE is defined with the REFERENCE-ONLY clause.
TEMP-TABLE has been previously returned from a procedure or a method as an OUTPUT TABLE with the BIND clause.
FOR EACH statement is on the TEMP-TABLE itself.
FOR EACH uses the BY clause.
The BY clause cannot be satisfied by one of the existing indexes on the TEMP-TABLE.
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1A
CAUSE:
Bug# OE00127845
FIX:
Upgrade to OpenEdge 10.1A01 or later. If upgrading to OpenEdge 10.1A01 or later is not feasible, then a workaround is to remove one of the conditions conditions specified among the above symptoms. In other words, either do not declare the TEMP-TABLE is with the REFERENCE-ONLY option (thus the BIND option is not used either), or copy the TEMP-TABLE to an identical TEMP-TABLE upon return from the procedure or method, and use the copy to perform the sorting (for this second option, it's probably best to copy the problematic TEMP-TABLE to another TEMP-TABLE that already has an index matching the sorting order that is intended by the BY clause on the original FOR EACH).