Open Handles & Queries

[Subhransu]

Hi,
I wanted to know how many handles and queries are open at a point of time during execution.
Please suggest.

Thanks.
Subhransu

 

[RealHeavyDude]

I suppose you mean dynamic query objects existing in memory. Handles are just variables that point to a handle-based object in memory.

In order to access the object you need to do a widget-tree walk on the session:

DEFINE VARIABLE hQuery AS HANDLE NO-UNDO.

ASSIGN hQuery = SESSION:FIRST-QUERY.

DO WHILE VALID-HANDLE ( hQuery ):

MESSAGE hQuery:NAME SKIP
hQueryREPARE-STRING
VIEW-AS ALERT-BOX INFO BUTTONS OK.
ASSIGN hQuery = hQuery:NEXT-SIBLING.

END.

HTH, RealHeavyDude.