Active Query Builder History v.2.13.15
+ The new QB.Web.Core.Events.SyncFinished event has been added. It's fired when the sync action is completed and data from the server is applied to controls. + The new QB.Web.Core.unbind(event, callback) method has been added. It allows unsubscribing the given handler from an event. = The QB.Web.Core.updateSQL method now puts the SQL query text to the editor. + MS SQL Server: Support for SELECT into local variable has been added. (SELECT @localVar = ...) - The bug with resolving baseName.fieldName references for stored procedures and table-valued functions has been fixed.
Active Query Builder History v.1.27.12
+ DB2: Database objects description fetching for iSeries/AS400 has been made.
Active Query Builder History v.1.27.12
+ DB2: Database objects description fetching for iSeries/AS400 has been made. = NexusDB 4: Package references are updated to the latest version 4.12. - MS SQL Server: Query Properties forms compilation for DevExpress controls has been fixed.
Active Query Builder History v.1.27.11
- The bug with removing a derived table via the context menu command has been fixed. - PostgreSQL: Parsing of string literals with ''-quoted apostrophes has been fixed. + MS SQL Server: Support of SELECT into local var (SELECT @localVar = 10) has been added. = Localization files have been updated, missing strings have been added.
Active Query Builder History v.1.27.11
- Query Transformer: The bug with creation of filter expression for a column with quoted aliases has been fixed. - The bug with removing a derived table via the context menu command has been fixed. - PostgreSQL: Parsing of string literals with ''-quoted apostrophes has been fixed. + MS SQL Server: Support of SELECT into local var (SELECT @localVar = 10) has been added. - Several DevExpress controls UI bugs have been fixed. - Compilation of Metadata Provider for DOA has been fixed. + Criteria Builder: The new ReadOnly and Color properties have been added. + Criteria Builder: Minor bug fixes and improvements have been made. - The "Field not found" bug in Criteria Builder has been fixed. - Text Editor: Selection movement on indent/unindent commands has been eliminated. - Text Editor: The bug in Replace command in selection has been fixed. = Localization files have been updated, missing strings have been added.
Active Query Builder History v.3.3.18.1065
+ MS SQL Server: Support for SELECT into local variable has been added. (SELECT @localVar = ...) - The bug with resolving baseName.fieldName references for stored procedures and table-valued functions has been fixed.
Active Query Builder History v.3.3.18.1065
+ MS SQL Server: Support for SELECT into local variable has been added. (SELECT @localVar = ...) - The bug with resolving baseName.fieldName references for stored procedures and table-valued functions has been fixed. - The bug with not refreshing fields for objects in the main query via RefreshDatasourcesMetadata call has been fixed. - The bug with not allowing to expand object type grouping nodes (Tables, Views, ...) in the Database Schema Tree has been fixed.
Active Query Builder History v.3.3.18.1065
+ MS SQL Server: Support for SELECT into local variable has been added. (SELECT @localVar = ...) - The bug with resolving baseName.fieldName references for stored procedures and table-valued functions has been fixed. - The bug with not refreshing fields for objects in the main query via RefreshDatasourcesMetadata call has been fixed. - The bug with not allowing to expand object type grouping nodes (Tables, Views, ...) in the Database Schema Tree has been fixed.
Active Query Builder History v.2.10.10.814
+ MS SQL Server: Support for SELECT into local variable has been added. (SELECT @localVar = ...) - Criteria Builder: The bug with loading of BETWEEN conditions for date and datetime columns has been fixed. - The bug with resolving baseName.fieldName references for stored procedures and table-valued functions has been fixed.
Active Query Builder History v.2.13.14
- The Edit Sub-query icon wasn't shown for Common Table Expressions. Fixed now. - Displaying the structure of complex queries in the Sub-query navigation bar has been corrected. - The bug in Criteria Builder with setting "is between" operator for date fields has been fixed. - MetadataLoadingOptions.IncludeFilter/ExcludeFilter: filtration by object type only has been fixed. - The QueryBuilder.LayoutSQL property now accepts empty strings without errors. - Correct column prefix now emitted for UDFs and stored procedures without aliases.
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!