Источник:
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