Kbase P100791: It is easier to investigate a dynamic query leak situation since OpenEdge 10
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/02/2005 |
|
Status: Unverified
GOAL:
How to investigate a dynamic query leak situation since OpenEdge 10?
GOAL:
New SESSION:FIRST-QUERY and hQuery:NEXT-SIBLING and hQuery:INSTANTIATING-PROCEDURE attributes introduced in openEdge 10
FIX:
The following code generates a report about all the Dynamic Queries of a session:
DEFINE VARIABLE hq AS HANDLE NO-UNDO.
hq = SESSION:FIRST-QUERY.
OUTPUT TO dynQuery.txt.
REPEAT WHILE hq <> ?:
DISPLAY hq:HANDLE LABEL "HANDLE "
hq:NAME LABEL "NAME" /* sadly, often left blank */
hq:IS-OPEN LABEL "IS-OPEN"
hq:NUM-RESULTS LABEL "NUM-RESULTS"
hq:INSTANTIATING-PROCEDURE:FILE-NAME FORMAT "X(50)" LABEL "Created in"
REPLACE(hq:PREPARE-STRING,"~n", " ") FORMAT "X(200)" LABEL "PREPARE-STRING"
WITH WIDTH 320.
hq = hq:NEXT-SIBLING.
END.
OUTPUT CLOSE.