Something interesting I came across in OE11 for temp-tables

Posted by Mark Davies on 05-Jun-2014 07:32

Hi,


Not sure how many of you have joined in the development of Progress applications in OE11, but if you have then you might be interested in a new class that will actually help you in debugging memory leaks for temp-tables. The following code snippet will loop through all of the temp-tables and give you information about the temp-table and where the temp-table was created. This is different from the SESSION:FIRST-BUFFER checks, these are the actual temp-tables - very useful ;-)

/******* Code Snippet *************/

USING Progress.Database.*.

DEFINE VARIABLE iCount    AS INTEGER     NO-UNDO.
DEFINE VARIABLE hTable    AS HANDLE      NO-UNDO.
DEFINE VARIABLE cProcName AS CHARACTER   NO-UNDO FORMAT "X(50)".

REPEAT iCount = 1 TO TempTableInfo:TempTableCount:
  TempTableInfo:GetTableInfoByPosition(INPUT iCount, OUTPUT hTable, OUTPUT cProcName).
  DISPLAY
    hTable:NAME    LABEL "Table Name"
    cProcName      LABEL "Procedure Name"
    hTable:DYNAMIC LABEL "Is Dynamic".
END.

/**************************/

All Replies

This thread is closed