Kbase P131524: Can't open static query on REFERENCE-ONLY temp-table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/11/2009 |
|
Status: Verified
SYMPTOM(s):
Defining static query on a REFERENCE-ONLY temp-table
Calling method or internal procedure which BINDs temp-table before query is opened
BIND and OPEN QUERY statements are in the same internal procedure or method
The following error occurs at runtime:
Attempt to reference uninitialized temp-table. (12378)
QUERY-OPEN for query <name> requires a previous QUERY-PREPARE. (7312)
FACT(s) (Environment):
OpenEdge 10.1x
All Supported Operating Systems
CAUSE:
Bug# OE00168677
FIX:
Upgrade to OpenEdge 10.2A or later.
Workaround:
Ensure the BIND is performed outside of the internal procedure/method.
For procedures:
- Move it to a separate internal procedure or to the procedure's main block
For classes:
- Move it to a separate method or to the class' constructor