ActiveQueryBuilder.View.WinForms 3.3.0.1036

• • ActiveQueryBuilder.Core (= 3.3.0.1036)

1. Improvements in the user queries API.

Previously, to edit the text of the saved user query, the user had to abandon the currently edited query, and the programmer could not keep track of this transition.

+ Now when the user selects the query editing command, the UserQueriesView.EditUserQuery event is triggered, in which the developer can save the current query before opening the new one, or he can open the user query in a new window. Also, the events are now fired on deleting, renaming and moving user queries between the folders. You can review all API changes in the release notes article.
+ The new helper class Core.UserQueries that consists of static methods has been added to perform various manipulations with user queries, such as adding, saving, moving, renaming them. It also has the means to save and load user queries serialized in XML format.

2. Editing Sub-query text apart from the entire query is possible now.
 
The component's API has allowed editing the text of a subquery long ago. The problem is that the text of the query modified by the user may have syntax errors, and the component lets switch to another subquery at any time. The erroneous text can not be saved, as it has to be parsed and translated into an object representation. In order not to lose the user changes when switching between subqueries, the component must be able to block this switch to inform the user of the error and offer ways out of the situation.

+ The new ActiveUnionSubQueryChanging event has been added to the QueryView and QueryBuilder components. The programmer can deny switching between sub-queries in this event handler by setting the e.Abort parameter to true.
+ The new SubQueryBreadcrumbsBar control has been made to display path from the main query to the currently active sub-query. It helps quickly switch to parent sub-queries.

3. Miscellaneous improvements.

+ The new MetadataLoadingOptions.AllowRecursiveVirtualObjects property allows specifying the mode of working with virtual objects. By default, referring to other virtual objects in the text of a virtual object is allowed. Such reference lets build a chain of objects to break complex queries in a series of simple ones. However, in this mode, you can't use the same-named physical object in a virtual object because of the emerging recursion. Setting this property to false prohibits creation chains of virtual objects, but allows to create virtual objects that substitute physical database objects.
+ Query Statistics: The UsedDatabaseObjects and UsedDatabaseObjectFields collections now include invalid objects and fields being used in the query. They differ from valid objects by the absence of MetadataObject (for objects) and MetadataField (for fields) references.
+ Usability of Expression Editor is improved now with the new dockable panels.
+ SQL Text Editor with syntax highlighting is used now to edit joining expression in the Properties bar and dialog.
+ Now it's possible to select multiple rows and drag them to reorder columns in the SELECT list.
+ The new SQLite metadata provider has been added.
- Removal of unused objects from the query when the QueryBuilder.BehaviorOptions.DeleteUnusedObjects property is turned to True has been fixed.