Kbase P119206: FOR EACH ... BREAK BY on a REFERENCE-ONLY temp-table fails
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/23/2009 |
|
Status: Unverified
SYMPTOM(s):
FOR EACH ... BREAK BY on a temp-table fails
Temp-table is defined as REFERENCE-ONLY
Attempt to reference uninitialized temp-table. (12378)
Temp-table is passed as parameter with BIND option before the FOR EACH gets executed
Other operations on the temp-table work as expected.
FACT(s) (Environment):
OpenEdge 10.1A
CAUSE:
Bug# OE00133002
CAUSE:
BREAK BY uses an implicit "look ahead" buffer to identify if it reaches the end of a break group. If this implicit buffer is based on the temp-table's default buffer (meaning: when referring to the table by table name), the binding for this look-ahead buffer fails.
FIX:
Upgrade to OpenEdge 10.1B or later
Workaround:
Define an explicit buffer for the temp-table, and use that in the FOR EACH ... BREAK BY loop.