Kbase P11457: 7334 when using CREATE BUFFER FOR TABLE table-handle-exp
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/06/2005 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.X
SYMPTOM(s):
CREATE BUFFER Statement with table-handle-expression
Could not create buffer object for table <table name>. (7334)
CAUSE:
Bug# 20021017-009
CAUSE:
The documentation says the syntax:
CREATE BUFFER handle FOR TABLE table-handle-exp
This is confusing, as the CREATE BUFFER fails if table-handle-exp is the actual Handle of the Temp-table object. The required handle is actually the temp-table's default buffer.
FIX:
Replace:
CREATE BUFFER bHandle FOR TABLE TEMP-TABLE TTest:HANDLE.
with:
CREATE BUFFER bHandle FOR TABLE TEMP-TABLE TTest:DEFAULT-BUFFER-HANDLE.
Note that in OpenEdge 10.0A and later, the CREATE BUFFER statement has been relaxed and will accept the temp-table's handle as well as it's default-buffer-handle.