Active query builder net edition

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 » 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:

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).

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 destroying

Is 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.