Active query builder net edition
Author: i | 2025-04-23
Download Active Query Builder .NET Edition for free. Active Query Builder .NET Edition - Active Query Builder is a visual SQL query builder System Utilities Active Query
Active Query Builder for .NET / Active Query Builder
April 29, 2016 Active Query Builder for .NET (WinForms and WPF) 3.1 is released. This is the final release. WinForms DevExpress controls UI is added, flat view mode for Database Schema Tree is made, lots of bugs are fixed. February 01, 2016 The new purchase options and the new beta version of Active Query Builder WinForms and WPF editions are available The sub-query navigation bar is updated, migration and quick start guides are published. December 14, 2015 Active Query Builder 3: new major version for WinForms and WPF is out. Download and try now! The first beta version of WinForms and WPF editions introduces the new component's architecture and the new sub-query navigation bar. September 02, 2015 Active Query Builder WinForms .NET Edition 2.10.3 is released Criteria Builder gets two-way syncronized with the Query Transformer. July 16, 2015 Active Query Builder WinForms .NET Edition 2.10 is released. Support for Netezza and Advantage DB SQL syntaxes is made. September 29, 2014 Active Query Builder 2 .NET Edition 2.9 is released. Ability to save queries as persistent reusable objects for using as views in the following queries is made. April 13, 2014 Active Query Builder 2 .NET Edition 2.8 is released. Support for MS SQL Server 2014 is added, Quick search in the Database Schema Tree is improved. February 03, 2014 Active Query Builder 2 .NET Edition 2.7 is released. Search in the Database Schema Tree and Add Object Window is made. November 25, 2013 Active Query Builder 2 .NET Edition 2.6 is released. Referenced tables and distinct field lookup with filtration for handy value selection in Criteria Builder is made. October 04, 2013 Active Query Builder 2 .NET Edition 2.5 is released. Browse for linked objects and add them to the query with a single click. Layout of datasource objects is now preserved after parsing of the modified query.
Active Query Builder .NET WinForms Edition
Active Query Builder » News » Active Query Builder .NET Edition News September 29, 2014 Active Query Builder 2 .NET Edition 2.9 is released. We're glad to announce the new version of Active Query Builder 2 .NET Edition. You can evaluate the new version by requesting the trial. Customers can download the new version in the Customer's area. What's new in the Active Query Builder .NET Edition version 2.9?Major improvements:Ability to save queries as persistent reusable objects for using as views in the following queries is added to the Professional .NET Subcription. Read more about the Reusable Queries in the Knowledge Book. Use the PanesConfigurationOptions.UserQueriesPaneVisible property to show/hide the new "Reusable Queries" snippet. To save and load user queries, use import/export methods of the QueryBuilder.UserQueries object.Advanced Expression Editor, SQL Text Editor and Criteria Builder controls are skinned correctly with the DevExpress controls UI in Professional .NET Subcription.Database Schema Tree performance is improved.Minor improvements and API changes:The new MetadataItem.UserData property is added to allow storing custom data for any metadata object.The Linked Objects menu now shows "No linked objects" item if no linked objects were found.It is now possible to set different color for focused links using the QueryBuilder.DesignPaneOptions.LinkStyle.LinkColorFocused property.Query Transformer now supports Skip() with ROW_NUMBER ranking function for DB2 and MS SQL Server 2005-2008.MS Access: Query Transformer is able to use Limit() with MS Access now.The Show Query By Parts demo is replaced with the improved SubQuery Results Preview demo.The DevExpress Demo source code sample project is added for C# and VB.NET.SQL syntax improvements and changes:Oracle: Support for SEARCH and CYCLE clauses in CTE subqueries is made.RedShift: Loading of metadata using PostgreSQL syntax provider is fixed.Vertica: Information about foreign keys can be extracted using native DB connection. MS Access: The parser now accepts identifiers quoted with backticks and convert them to square brackets.MS SQL Server: New MSSQL 2012 analytic functions are added.MS SQL Server: OFFSET-FETCH clause is supported by Query Transformer.MS SQL Server: IIF function and "WITHIN GROUP" clause are supported now.MS SQL Server: Loading of foreign keys for SQL Server 2000 and earlier is fixed.PostgreSQL: Parsing of ROW clause is speeded up.PostgreSQL: Metadata loading is speeded up. at ActiveDBSoft. » All Active Query Builder .NET Edition news Comments by Disqus:Active Query Builder WPF .NET Edition
Reverse engineering. It is an easy-to-use tool allowing you to work both with logical and physical data models in the form of an entity-relationship (IDEF1X notation) diagram. The product is intended for... DOWNLOAD GET FULL VER Cost: $179.00 USD License: Demo Size: 1.1 MB Download Counter: 13 Released: October 03, 2011 | Added: October 03, 2011 | Viewed: 1962 Private Shell SSH Client 2.1 Private Shell is an easy to configure SSH client for Windows. Autoconfiguration wizard helps you to setup basic and advanced SSH sessions. Even if you are not familiar with SSH, you can easily establish connections that use public key authentication and provide ssh tunneling for third-party... DOWNLOAD GET FULL VER Cost: $29.95 USD, 200.00 RUB License: Shareware Size: 2.4 MB Download Counter: 102 Released: January 27, 2005 | Added: January 30, 2005 | Viewed: 2280 Advanced OPC Data Logger 2.0.0.37 If you need to organize effectual data exchange between your system and an OPC server, you may face the problem of choosing the right appropriate and the most suitable tool for your immediate needs. However, this needs becomes history once you have downloaded Advanced OPC Data Logger, as this... DOWNLOAD GET FULL VER Cost: $65.00 USD, 55.00 EUR License: Shareware Size: 7.3 MB Download Counter: 4 Released: March 25, 2008 | Added: March 28, 2008 | Viewed: 1337 MightyQuery 1.0.0 MightyQuery is a single user SQL database management software working with data stored as comma separated values (.csv, .txt) in plain, flat, textual files. It is serverless, self-contained, simple and effective SQL DBMS for querying CSV files. In contrast to most database systems, MightyQuery... DOWNLOAD GET FULL VER Cost: $22.00 USD, 15.00 EUR License: Shareware Size: 3.0 MB Download Counter: 3 Released: October 01, 2009 | Added: October 03, 2009 | Viewed: 1390 Active Query Builder ActiveX Edition 1.7.9 Active Query Builder is a .Net-ready ActiveX visual query builder component to build complex SQL queries via an intuitive visual interface easily. It differs from other query builders by its powerful SQL parser that correctly handles SQL queries containing multiple nested joins and other fine... DOWNLOAD GET. Download Active Query Builder .NET Edition for free. Active Query Builder .NET Edition - Active Query Builder is a visual SQL query builder System Utilities Active Query Active Query Builder .NET Edition Download. Downloading Active Query Builder .NET Edition 1.6Active Query Builder .NET Edition - reviewpoint.org
Made. January 21, 2015 Active Query Builder VCL Edition v.1.24.9 - Component usage under the Win64 platform is fixed. = Scanner performance optimizations are made. December 19, 2014 Active Query Builder VCL Edition v.1.24.8 = DB2: The query to load default schema is corrected for older mainframes.= DB2: Metadata objects loading is improved for older mainframes: fallback to QSYS2.SYSTABLES is made.- Loading join conditions with references to objects from parent query is fixed.- Loading FROM clause enclosed with parenthesis is fixed.- Memory leak is fixed. December 05, 2014 Active Query Builder VCL Edition v.1.24.7 + SQLite: Support CTE at sub-queries level is added.= Oracle: Oracle8i compatibility fixes are made.= Comments parsing is fixed. November 14, 2014 Active Query Builder VCL Edition v.1.24.6 + Support for AdvantageDB SQL syntax is made.+ The new Subquery Results Preview demo is added to illustrate working with subqueries independently and using Query Transformer to allow previewing of sub-query result data.+ The new AlwaysWrapInSubQuery property is added to TacQueryTransformer to instruct the component to wrap original query in sub-query even it is not necessary in order to perform the requested modifications.= AdvantageDB Metadata Provider: minor bugs are fixed. October 29, 2014 Active Query Builder VCL Edition v.1.24.5 - General SQL parsing bug is fixed. October 22, 2014 Active Query Builder VCL Edition v.1.24.4 = SQL parser fix is made (affects all SQL dialects).Active Query Builder .NET Professional Edition
November 22, 2024 Active Query Builder VCL Edition v.1.36.2 + The new SetAliasesDemo is added.- DevExpress: The bug with opening the Link properties form is fixed.- Snowflake DB: The parser ambiguity that caused freezing is eliminated.- Link Properties form: The natural join editor is hidden if the syntax does not support them. November 07, 2024 Active Query Builder VCL Edition v.1.36.1 + MS SQL Server: Support for pasrsing PIVOT and UNPIVOT is added.- MS SQL Server: Support of aliases after join object hint (NOLOCK) is added.- IBM DB2: The bug with parsing of VALUES clause is fixed.- TacCriteriaBuilder: The exception on inserting multiple values where some of them are empty is eliminated. August 30, 2024 Active Query Builder VCL Edition v.1.36.0 + Oracle, PostgreSQL, MySQL, Snowflake: Support for NATURAL and LATERAL joins is added.+ MS SQL Server: Support for CROSS/OUTER APPLY is added.= PostgreSQL: Support for ONLY and [NOT] MATERIALIZED CTE hints is added. July 11, 2024 Active Query Builder VCL Edition v.1.35.6 = Support for numeric order in queries with an asterisk item is improved.- SQL Text Editor: List of keywords for PostgreSQL is fixed. July 05, 2024 Active Query Builder VCL Edition v.1.35.5 + Full support of numeric column references in the ORDER BY clause is made.+ Column alias is generated now on adding a column to the ORDER BY by UI.- PostgreSQL: Keywords list is fixed.= Criteria Builder: Value conversion on changing the field reference is fixed.- Criteria Builder: Controls hiding is fixed. April 26, 2024 Active Query Builder VCL Edition v.1.35.4 = ANSI SQL/92, SQL/2003: Minor compatibility fixes are made.= Handling of the ORDER BY by column index for unnamed columns is fixed.= TacBaseMetadataProvider, TacTextDocument: The new OnExecuteThread event is added.- Pervasive: The bug with fields ordering is fixed.- Criteria Builder: The crash on items destroyingActive Query Builder .NET Edition - FreeDownloadManager
May 19, 2015 Active Query Builder VCL Edition v.1.25.0 + Support for RAD Studio XE8 is added.+ Compatibility with VCL Styles is improved.+ Support of RTL languages is improved.+ Ability to select muptiple rows in the Query Columns Grid eases re-ordering of query columns.= The Aggregate column of the Query Columns Grid is moved closer to the Grouping column.= Now when query grouping is cancelled by unchecking the main Grouping option, the ConditionType ("Criteria For" column) is set to ctWhere ("For values") only for non-aggregated columns.+ IacTask: Support for cancelation of the task in another thread is made.+ IacAsyncSql: The OnCustomizeDataset event is added to change parameters of dataset after it's creation.+ IacAsyncSql: Ability to use the given DB connection is added.= The QueryBuilder.OnSelectListColumnWidthsChanged event is now fired only for changes made by the user.- QueryTransformer: Wrapping of queries with several unnamed columns is fixed.= ANSI SQL/2003: Using the TABLE wrapper for stored procedures in FROM is possible now.+ AdvantageDB: Support for IIF builtin function is made.- AdvantageDB: Parsing of the LEFT and RIGHT builtin functions is fixed.- MySQL: Support for CHAR builtin function is made.- DB2: Duplication of the TABLE wrapper for stored procedures is fixed.= Informix: The system "INFORMIX" schema now treated as non-system if no other schemas are found. March 24, 2015 Active Query Builder VCL Edition v.1.24.12 - PostgreSQL: LIKE (ANY|SOME|ALL) is supported now.- Query Transformer: Construction of NOT BETWEEN condition is fixed.= Column aliases entered in the Query column list are always quoted now to preserve the case. + The new QueryBuilder.OnSelectListColumnWidthsChanged is made. Helpers to get/set columns widths are added.+ Query columns list height and columns width are preserved now on query reloading and manual SQL text changes.= The QueryBuilder.ColumnsPaneHeight setter is improved.- The QueryBuilder.Clear method is fixed.= TacBaseSyntax: Better date/time parsing helpers are made. March 10, 2015 Active Query Builder VCL Edition v.1.24.11 = Focus is not moved on mouse hover over datasources on the Design pane if the component is not focused.= The TacSubQuery.SetSql method now accepts CTE for the main query.= The TacUnionSubQuery.SQL property now emits empty string for empty queries.= Support for database connection activity logging is made.- Incorrect loading of ORDER BY is fixed. February 06, 2015 Active Query Builder VCL Edition v.1.24.10 + Support for NexusDB v.4 is made.= The OnActiveSubQueryChanging and OnActiveUnionSubQueryChanging events signatures are changed. Now you can deny sub-query changing.= Minor parsing speed improvements are. Download Active Query Builder .NET Edition for free. Active Query Builder .NET Edition - Active Query Builder is a visual SQL query builder System Utilities Active Query Active Query Builder .NET Edition Download. Downloading Active Query Builder .NET Edition 1.6Comments
April 29, 2016 Active Query Builder for .NET (WinForms and WPF) 3.1 is released. This is the final release. WinForms DevExpress controls UI is added, flat view mode for Database Schema Tree is made, lots of bugs are fixed. February 01, 2016 The new purchase options and the new beta version of Active Query Builder WinForms and WPF editions are available The sub-query navigation bar is updated, migration and quick start guides are published. December 14, 2015 Active Query Builder 3: new major version for WinForms and WPF is out. Download and try now! The first beta version of WinForms and WPF editions introduces the new component's architecture and the new sub-query navigation bar. September 02, 2015 Active Query Builder WinForms .NET Edition 2.10.3 is released Criteria Builder gets two-way syncronized with the Query Transformer. July 16, 2015 Active Query Builder WinForms .NET Edition 2.10 is released. Support for Netezza and Advantage DB SQL syntaxes is made. September 29, 2014 Active Query Builder 2 .NET Edition 2.9 is released. Ability to save queries as persistent reusable objects for using as views in the following queries is made. April 13, 2014 Active Query Builder 2 .NET Edition 2.8 is released. Support for MS SQL Server 2014 is added, Quick search in the Database Schema Tree is improved. February 03, 2014 Active Query Builder 2 .NET Edition 2.7 is released. Search in the Database Schema Tree and Add Object Window is made. November 25, 2013 Active Query Builder 2 .NET Edition 2.6 is released. Referenced tables and distinct field lookup with filtration for handy value selection in Criteria Builder is made. October 04, 2013 Active Query Builder 2 .NET Edition 2.5 is released. Browse for linked objects and add them to the query with a single click. Layout of datasource objects is now preserved after parsing of the modified query.
2025-04-10Active Query Builder » News » Active Query Builder .NET Edition News September 29, 2014 Active Query Builder 2 .NET Edition 2.9 is released. We're glad to announce the new version of Active Query Builder 2 .NET Edition. You can evaluate the new version by requesting the trial. Customers can download the new version in the Customer's area. What's new in the Active Query Builder .NET Edition version 2.9?Major improvements:Ability to save queries as persistent reusable objects for using as views in the following queries is added to the Professional .NET Subcription. Read more about the Reusable Queries in the Knowledge Book. Use the PanesConfigurationOptions.UserQueriesPaneVisible property to show/hide the new "Reusable Queries" snippet. To save and load user queries, use import/export methods of the QueryBuilder.UserQueries object.Advanced Expression Editor, SQL Text Editor and Criteria Builder controls are skinned correctly with the DevExpress controls UI in Professional .NET Subcription.Database Schema Tree performance is improved.Minor improvements and API changes:The new MetadataItem.UserData property is added to allow storing custom data for any metadata object.The Linked Objects menu now shows "No linked objects" item if no linked objects were found.It is now possible to set different color for focused links using the QueryBuilder.DesignPaneOptions.LinkStyle.LinkColorFocused property.Query Transformer now supports Skip() with ROW_NUMBER ranking function for DB2 and MS SQL Server 2005-2008.MS Access: Query Transformer is able to use Limit() with MS Access now.The Show Query By Parts demo is replaced with the improved SubQuery Results Preview demo.The DevExpress Demo source code sample project is added for C# and VB.NET.SQL syntax improvements and changes:Oracle: Support for SEARCH and CYCLE clauses in CTE subqueries is made.RedShift: Loading of metadata using PostgreSQL syntax provider is fixed.Vertica: Information about foreign keys can be extracted using native DB connection. MS Access: The parser now accepts identifiers quoted with backticks and convert them to square brackets.MS SQL Server: New MSSQL 2012 analytic functions are added.MS SQL Server: OFFSET-FETCH clause is supported by Query Transformer.MS SQL Server: IIF function and "WITHIN GROUP" clause are supported now.MS SQL Server: Loading of foreign keys for SQL Server 2000 and earlier is fixed.PostgreSQL: Parsing of ROW clause is speeded up.PostgreSQL: Metadata loading is speeded up. at ActiveDBSoft. » All Active Query Builder .NET Edition news Comments by Disqus:
2025-04-07Made. January 21, 2015 Active Query Builder VCL Edition v.1.24.9 - Component usage under the Win64 platform is fixed. = Scanner performance optimizations are made. December 19, 2014 Active Query Builder VCL Edition v.1.24.8 = DB2: The query to load default schema is corrected for older mainframes.= DB2: Metadata objects loading is improved for older mainframes: fallback to QSYS2.SYSTABLES is made.- Loading join conditions with references to objects from parent query is fixed.- Loading FROM clause enclosed with parenthesis is fixed.- Memory leak is fixed. December 05, 2014 Active Query Builder VCL Edition v.1.24.7 + SQLite: Support CTE at sub-queries level is added.= Oracle: Oracle8i compatibility fixes are made.= Comments parsing is fixed. November 14, 2014 Active Query Builder VCL Edition v.1.24.6 + Support for AdvantageDB SQL syntax is made.+ The new Subquery Results Preview demo is added to illustrate working with subqueries independently and using Query Transformer to allow previewing of sub-query result data.+ The new AlwaysWrapInSubQuery property is added to TacQueryTransformer to instruct the component to wrap original query in sub-query even it is not necessary in order to perform the requested modifications.= AdvantageDB Metadata Provider: minor bugs are fixed. October 29, 2014 Active Query Builder VCL Edition v.1.24.5 - General SQL parsing bug is fixed. October 22, 2014 Active Query Builder VCL Edition v.1.24.4 = SQL parser fix is made (affects all SQL dialects).
2025-04-07November 22, 2024 Active Query Builder VCL Edition v.1.36.2 + The new SetAliasesDemo is added.- DevExpress: The bug with opening the Link properties form is fixed.- Snowflake DB: The parser ambiguity that caused freezing is eliminated.- Link Properties form: The natural join editor is hidden if the syntax does not support them. November 07, 2024 Active Query Builder VCL Edition v.1.36.1 + MS SQL Server: Support for pasrsing PIVOT and UNPIVOT is added.- MS SQL Server: Support of aliases after join object hint (NOLOCK) is added.- IBM DB2: The bug with parsing of VALUES clause is fixed.- TacCriteriaBuilder: The exception on inserting multiple values where some of them are empty is eliminated. August 30, 2024 Active Query Builder VCL Edition v.1.36.0 + Oracle, PostgreSQL, MySQL, Snowflake: Support for NATURAL and LATERAL joins is added.+ MS SQL Server: Support for CROSS/OUTER APPLY is added.= PostgreSQL: Support for ONLY and [NOT] MATERIALIZED CTE hints is added. July 11, 2024 Active Query Builder VCL Edition v.1.35.6 = Support for numeric order in queries with an asterisk item is improved.- SQL Text Editor: List of keywords for PostgreSQL is fixed. July 05, 2024 Active Query Builder VCL Edition v.1.35.5 + Full support of numeric column references in the ORDER BY clause is made.+ Column alias is generated now on adding a column to the ORDER BY by UI.- PostgreSQL: Keywords list is fixed.= Criteria Builder: Value conversion on changing the field reference is fixed.- Criteria Builder: Controls hiding is fixed. April 26, 2024 Active Query Builder VCL Edition v.1.35.4 = ANSI SQL/92, SQL/2003: Minor compatibility fixes are made.= Handling of the ORDER BY by column index for unnamed columns is fixed.= TacBaseMetadataProvider, TacTextDocument: The new OnExecuteThread event is added.- Pervasive: The bug with fields ordering is fixed.- Criteria Builder: The crash on items destroying
2025-04-02Is eliminated. February 28, 2024 Active Query Builder VCL Edition v.1.35.3 - Delphi 2007: Datasource fields list drawing issues are fixed.- Criteria Builder: The crash on initializing the popup list in some cases is fixed. February 22, 2024 Active Query Builder VCL Edition v.1.35.2 = Pervasive: The load of metadata is improved.= Installer: Sources and packages are extracted into the public documents folder.- RAD Studio 12: Datasource painting is fixed.- RAD Studio 12: Datasource fields filter paiting with Delphi skins is fixed.- Datasources layout for apps with Delphi skins is fixed. January 24, 2024 Active Query Builder VCL Edition v.1.35.1 = Oracle: Parsing expressions with parentheses is speeded up.= MySQL: Parsing of queries with "=false" and "=true" is speeded up.= MySQL: New aggregate functions are added.= Snowflake: The bug with some aggregate function names is fixed.= Snowflake: Support for POSITION and FLATTEN functions is made.= MS SQL Server: Support for WITHIN expression is made.= SQL text editor: New SQL Server functions are added to the suggestions list.- SQL text editor: Suggestions list tooltips are back.- RAD Studio 12: The bug with clicking on checkboxes in the datasource field list when VCL themes are turned on is fixed.- Old Delphi version incompatibilities are fixed. November 23, 2023 Active Query Builder VCL Edition v.1.35.0 + Support for RAD Studio 12 is added.+ Criteria Builder: The ability to paste a list of values from clipboard to the "in list" editor is made.+ Firebird: Server version autodetection is added.+ Oracle: Support for percentile_cont, percentile_disc functions is added.+ Denodo: Support for analytical functions is added.- DevExpress: Exception on destroying a datasource is elimitated.- NexusDB: The bug with identifiers comparison is fixed.
2025-04-22