Kbase P89191: Error 9085 with the Temp table CLEAR method
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/07/2004 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.x
SYMPTOM(s):
Error 9085 with the Temp table CLEAR method
CLEAR method may not be called on a static temp-table object, nor on a
dynamic one with records; use buffer:EMPTY-TEMP-TABLE. (9085)
Trying to re-use a dynamic Temp Table handle with the CLEAR method results in error 9085.
CAUSE:
This is a known issue being investigated by Development
FIX:
As a work around, instead of using the CLEAR method, delete the temp table and re-create it. i.e.
DELETE OBJECT hTT.
CREATE TEMP TABLE hTT.