Downloads

Active Query Builder 2 ASP.NET Edition History

June 22, 2018

Active Query Builder 2 ASP.NET Edition v.2.14.2

= Numeric constants in ORDER BY are converted to corresponding expressions
  now.
- The bug with the stored procedure parameters retrieval on servers with
  specific collation has been fixed.
+ Oracle: Loading of stored procedure parameters from the server system
  catalog is supported now.
= Oracle: Support for the new Oracle 12c LISTAGG syntax has been added.
- Teradata: The bug with autodetection of new versions has been fixed.
- SQLite: Parsing of queries with RIGHT and FULL joins now results in the 
  parsing error.
- MS SQL Server: Parsing of qualified names with skipped components has been
  fixed.
- MS SQL Server: Loading of fields for linked servers without database or 
  schema has been fixed.
= PostgreSQL parser has been optimized.
= SQLite: Keywords list has been filled.
- MySQL: Support of STDDEV function has been fixed.
+ Sybase: Support for window functions has been added.
- DB2: NULL is parsed now as a constant, not as an identifier.
- DB2: Parsing of FOR UPDATE, FOR READ ONLY, ISOLATION and 
  OPTIMIZE FOR in an arbitrary order has been fixed.

November 30, 2017

Active Query Builder 2 ASP.NET Edition v.2.14.1

+ Batch loading of fields and foreign keys for Oracle, MS SQL Server and 
  DB2 has been implemented.
+ The new SyntaxProvider.UseBatchMetadataLoading property has been added
  (default: True).
- Criteria Builder: The bug with "between" operator for date fields has 
  been fixed.
- Sybase: Detection of newer versions of SQL Anywhere has been fixed.
- Sybase: Case-sensitive identifiers are implied for Sybase ASE.
- Query Transformer: Applying both pagination and sort order has been fixed.

October 03, 2017

Active Query Builder 2 ASP.NET Edition v.2.14.0

- Minor link drawing glitches have been fixed.
- Client-side programmatic query creation API with aggregates and grouping
  has been fixed.
+ PostgreSQL: Support for "$n"-style positional parameters has been added.
- Oracle: List of keywords used as valid identifiers has been updated.
- MySQL: Some valid identifiers were erroneously treated as keywords. 
  Fixed now.

September 15, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.16

+ MySQL: Support for DateDiff, TimeDiff, TimestampDiff functions 
  has been added.
= Internal HTTP session optimizations have been made.

September 06, 2017

Active Query Builder 2 ASP.NET Edition 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.

August 18, 2017

Active Query Builder 2 ASP.NET Edition 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.

July 14, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.13

- The bug with resizing of datasource on Design Pane has been fixed.
= Diagnostic error message is now shown if there's no access to the session
  store.
= MS SQL Server: List of keywords has been updated.

July 04, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.12

- The CopyLocal property is now set to True for all references to Active 
  Query Builder properties in the demo projects.
- The bug with loading of multiple unnamed foreign keys has been fixed.

June 16, 2017

Active Query Builder 2 ASP.NET Edition 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.

May 17, 2017

Active Query Builder 2 ASP.NET Edition v.2.13.10

= The "object.*" item is added now to the query on dropping an object to 
  the Query Columns Grid.
- The bug with an object added to the query twice on dropping it between 
  the Design Pane and the Query Columns Grid has been fixed.
- The bug with incorrect displaying of fields in the search results in the
  Database Schema Tree has been fixed,
- A memory leak on the client has been eliminated.

Product Summary

 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:

Tweets

Testimonials

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!


Social networks