axaptapedia: DEV QueryBrowser

[Blog bot]

Источник: http://www.axaptapedia.com/DEV_QueryBrowser
==============

Summary:
[[DEV_QueryBrowser]]

'''[http://www.axaptapedia.com/images/2/...owser_v204.zip download (13k)]'''


Often when we work with queries we need to see the result of the query. To do this usually we use [[QueryRun]] class:

QueryRun qr;
qr = new QueryRun(query);

while(qr.next())
{

}


To see necessary fields developer need to descriebe every field inside while loop. Like this:

QueryRun qr;
MyTable myTable;
AnotherMyTable anotherMyTable;
;

qr = new QueryRun(query);

while(qr.next())
{
myTable = qr.get(tableNum(MyTable));
anotherMyTable = qr.get(tableNum(AnotherMyTable));

info(strFmt('%1 %2', myTable.Field1, anotherMyTable.Field2)); // and so on...
}


And how about when we need control 10 and more fields?
To get rid this routine was developed QueryBrowser.

=== Features ===
[[Image:QueryBrowser SQL.jpg|thumb|QueryBrowser window]]

*QueryBrowser allows browse queries from [[AOT]] or custom queries as such as TableBrowser works.

For browsing query use construction:
new DEV_QueryBrowser().run( _query );
where _query - browsing query. e.g. :
new DEV_QueryBrowser().run( new Query(queryStr(InventSum)) );

[[Image:QueryBrowser XML.jpg|thumb|QueryBrowser XML statement]]

*The tool is integrated with AOT. To browse query from AOT just click Add-Ins\Browse Query.
*Ability to watch on XML structure of query.
*QueryBrowser capable with [[Tabax]].

=== Restrictions ===
QueryBrowser correctly displays queries with linear structure.
Queries with tree-type structure will be correctly displayed in case when every data source in query has FetchMode 1:1 only.

=== Feedback ===
If you have any ideas or questions, you may find me at
[http://axforum.info Axforum]
[http://axforum.info/forums/member.php?u=5103 Russland]

[[Category:Development tools]]


Источник: http://www.axaptapedia.com/DEV_QueryBrowser