Consultor Eletrônico

Solution ID: P3217

SYMPTOM(s):

Shared temp-table

Newly created temp-table record is not available in other procedures

CAUSE:

There is a transaction mechanism for temp-tables even if they are defined with NO-UNDO. The procedure that creates or modifies the record is using the default buffer of the temp-table which is scoped to the full 4GL session. Thus, the newly created record is not available to other procedures until it is released.

Using another buffer defined in the procedure that creates or modifies the records solves the problem because its scope is limited to the procedure. Thus the latest created record is automatically released when that procedure ends.

FIX:

Explicitly RELEASE the record at the end of the transaction.
Another option is to use another buffer to create or modify the records.