DEV QueryBrowser2



This version of DEV_QueryBrowser2 owes it's existence to the excellent Tool DEV_QueryBrowser created by Ruslan Goncharov 

DEV_QueryBrowser2 is a continuation of Ruslan's original Tool. The Core of this Tool uses code developed by Ruslan while extending it with modifications which I wished to have.

I've dropped the XML part as well as the AOT Form. This is a stand alone class which builds it's own form dynamically. Also included is a cyclicity on rebuilding the result Set every minute and displaying Result set information such as count, runtime, and change frequency, thereby allowing the form to stay open and continuously monitor the query. A lookup on container fields is also possible.

Included with this version is a static Method HavingList which allows for 'GroupBy - Having'-Clauses in the query. The countLoops and countPrim Methods are reworks of the standard Global Methods which are way more efficient (except when using the HavingList, where ist give the wrong count).

The Class can be called using the static Method newQueryBrowser which accepts a query as it's parameter and automatically builds the form.

There are no Labels used here. All Text is assigned to global variables in the assignLabels Method. If you wish to change the label text, then please do so in this method.

The call to this class looks like this: DEV_QueryBrowser2::newQueryBrowser(query).run;