Active Query Builder History v.3.3.11.1058
+ SQL Text Editor: The new LoadMetadataOnCodeCompletion property has been added. It prescribes to load metadata if it hasn't been loaded yet on displaying the suggestion popup list. ! The bug with loading of conditions joined with OR has been fixed. They were converted to AND in some cases. - Query Transformer: The bug on transforming the query with a stored procedure has been fixed. - Loading of foreign keys has been fixed. - Other minor bugs have been fixed.
Active Query Builder History v.3.3.11.1058
+ SQL Text Editor: The new LoadMetadataOnCodeCompletion property has been added. It prescribes to load metadata if it hasn't been loaded yet on displaying the suggestion popup list. ! The bug with loading of conditions joined with OR has been fixed. They were converted to AND in some cases. - Query Transformer: The bug on transforming the query with a stored procedure has been fixed. - Loading of foreign keys has been fixed. - Other minor bugs have been fixed.
Active Query Builder History v.3.3.10.1057
! The bug that caused slow initialization of the component, especially on the large database schema has been fixed. = The MetadataItem.FindItems(filter, type) method now takes the filter.ObjectType property into account. = MetadataObject.Expression property setter now checks expression for recursion loops.
Active Query Builder History v.3.3.10.1057
! The bug that caused slow initialization of the component, especially on the large database schema has been fixed. = The MetadataItem.FindItems(filter, type) method now takes the filter.ObjectType property into account. = MetadataObject.Expression property setter now checks expression for recursion loops. - The bug with quotation of incorrect SQL expressions with double quotes instead of apostrophes has been fixed.
Active Query Builder History v.3.3.10.1057
! The bug that caused slow initialization of the component, especially on the large database schema has been fixed. = The MetadataItem.FindItems(filter, type) method now takes the filter.ObjectType property into account. = MetadataObject.Expression property setter now checks expression for recursion loops. - The bug with quotation of incorrect SQL expressions with double quotes instead of apostrophes has been fixed. - The exception on double clicking on a datasource has been eliminated.
Active Query Builder History v.2.13.11
! Default location of JS and CSS files has been changed. The JS and CSS directories must reside in the directory of the web page or the parent control, formerly - in the server root folder. As before, you can override the default settings as needed. Please refer to the Quick Start Guides for details. - The error appeared in the JavaScript console in IE on deleting a datsource has been fixed. - The bug with the Undefined parameter in the callback of refreshSql method called after the session expiration has been fixed. - The bug with quotation of incorrect SQL expressions with double quotes instead of apostrophes has been fixed. + The "Alternate names" demo for MVC5 has been added.
Active Query Builder History v.1.27.1.1
+ Sybase ASA: Compatibility with older server versions has been improved. + NativeDB Metadata Provider is capable of loading objects and foreign keys now.
Active Query Builder History v.1.27.1
+ Conditions for the same left part joined using the OR operator are merged into a single cell now. + The new WhereNewLineBefore and HavingNewLineBefore properties have been added to IActiveQueryBuilderX.SelectFormat group to add new lines before the specified types of operators. Possible values are the following: None, TopmostOr, TopmostLogical, AllLogical. - IBM DB2: The bug with appending LIMIT OFFSET by the Query Transformer has been fixed. - Oracle: A workaround for Microsoft ODBC driver bug has been made. Fields are loaded now using the non-parametrized query if the parametrized query fails. - The bug with loading of CTE referred in a reverse order has been fixed. - MS SQL Server: Fake ORDER BY is added correctly now if there is no ordering in the transformed query. - Oracle: Loading of fields for synonyms has been fixed.
Active Query Builder History v.1.27.1
+ Support of DevExpress 17.1 has been added. + Conditions for the same left part joined using the OR operator are merged into a single cell now. - IBM DB2: The bug with appending LIMIT OFFSET by the Query Transformer has been fixed. - FireDAC: The DataSet.CursorKind property is set to ckForwardOnly for uni-directional datasets now. - Oracle: A workaround for Microsoft ODBC driver bug has been made. Fields are loaded now using the non-parametrized query if the parametrized query fails. - The bug with loading of CTE referred in a reverse order has been fixed. - MS SQL Server: Fake ORDER BY is added correctly now if there is no ordering in the transformed query. - Oracle: Loading of fields for synonyms has been fixed.
Active Query Builder History v.3.3.9.1056
- IBM DB2: Database objects are now loaded from the server if loading from driver fails.
Active Query Builder WinForms .NET Edition:
Active Query Builder WPF .NET Edition:
Active Query Builder ASP.NET Edition:
Active Query Builder Java Edition:
Active Query Builder ActiveX Edition:
Active Query Builder VCL Edition:
We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!
We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...
In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!