Forum Post: Something interesting I came across in OE11 for temp-tables in memory

[markd@prosoftit.co.za]

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" hTableYNAMIC LABEL "Is Dynamic". END. /**************************/

Continue reading...