Kbase P7211: Creation of a dynamic temp-table generates error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/17/2004 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
Windows
SYMPTOM(s):
Error creating a dynamic temp-table record buffer.
Error "Unknown or ambiguous table. (725)".
CAUSE:
Invalid code construction.
ttHandle:TEMP-TABLE-PREPARE("statex").
b1Handle = ttHandle:DEFAULT-BUFFER-HANDLE.
b2Handle = BUFFER state:HANDLE.
b3Handle = BUFFER SalesRep:HANDLE.
FOR EACH state:
CREATE statex. /* Line of code that generates error */
The temp-table-prepare expression, is only a character expression that evaluates to a temp-table name to be used in subsequent query statement, not a CREATE TABLE Statement.
FIX:
Use BUFFER-CREATE instead of CREATE Table.
Example Code Snippet:
ttHandle:TEMP-TABLE-PREPARE("statex").
b1Handle = ttHandle:DEFAULT-BUFFER-HANDLE.
b2Handle = BUFFER state:HANDLE.
b3Handle = BUFFER SalesRep:HANDLE.
FOR EACH state:
b1Handle:BUFFER-CREATE.