Downloads

Active Query Builder History History

March 26, 2018

Active Query Builder History v.3.1.2

+ Corporate version: The new Cross-domain demo project which illustrates
  hosting of HTTP and Active Query Builder handlers on different sites has
  been added.
+ The new setting lets determine the location of Active Query Builder
  handlers in case of placing them into a virtual directory using standalone
  IIS server. You can define it in the Application_Start method using the
  BaseHandler.VirtualDirectory property in case of server-side rendering
  mode and in via the AQB.Web.virtualDirectory JavaScript property in the
  case of client-side rendering.
+ The new CriteriaBuilder.AutoLoad property prescribes to request the list
  of columns during the component initialization.
+ The new CriteriaBuilder.AutoSubscribe property instructs to subscribe to
  changes of the QueryBuilder component with the same id during the
  component initialization. 
+ The new LogHandlerStateOnExceptions configuration option prescribes to
  write the serialized component state and request body to the log in case
  of unhandled exceptions arose during the processing of this request.
+ The new BeforeProcess and AfterProcess events have been added to 
  AqbHandler and CbHandler objects to log the activity of handlers.
+ The new BaseHandler.Register() static method lets pre-initialize Active
  Query Builder handlers which is useful in multi-server environments.
- IE9 markup fixes have been made.
- The bug on touch-enabled Windows 10 systems in Chrome and Firefox has 
  been fixed.
- The bug with not displaying the Custom Expression Editor button without
  custom jQueryUI theme has been fixed.
- The bug with too many brackets for columns that have spaces has been
  fixed.

March 15, 2018

Active Query Builder History v.2.10.13.821

= Parsing of incorrect/incomplete "IN" expressions in condition cells of
  the Query Columns List has been improved.
= PostgreSQL parser has been optimized.
= Sqlite: Keywords list has been filled.
- The bug with the stored procedure parameters retrieval on servers with
  specific collation has been fixed.
- MySQL: Support of STDDEV function has been fixed.

March 15, 2018

Active Query Builder History v.1.28.7

- Access violation on creating TacQueryBuilder component in RAD Studio 10.2.3
  has been fixed.
= SQLite: The list of reserved words has been filled.

March 15, 2018

Active Query Builder History v.1.28.7

= SQLite: The list of reserved words has been filled.

March 10, 2018

Active Query Builder History v.3.1.1

+ Client-side optimizations when working with a large number of fields in
  source tables and in the query have been made.
= The ObjectTreeView.DefaultExpandMetadataType now expands the whole tree 
  on setting it to the MetadataType.All value.
+ The new Query Results demo has been added to the CustomStorage demo
  project.
= SQL Text Editor is now resizable by default.
= The QueryBuilder.dispose and CriteriaBuilder.dispose methods are
  corrected. The new bool parameter instructs to clear the server-side 
  instance as well.
+ The new QueryBuilder.LoadScript bool property disables loading of 
  embedded javascript resource. Setting it to false requires manual 
  addition of the aqb.client.js script to your web page.
- The bug with not expanding the tree down to objects when objects are
  grouped by type has been fixed.
- The bug with calculation of the link direction on the Canvas has been
  fixed.
- The bug with dragging rows in the Query Columns Grid has been fixed.
- Minor bugs have been fixed.

March 07, 2018

Active Query Builder History v.3.4.7.1084

= SQLite: The list of keywords has been filled.
- The bug with the stored procedure parameters retrieval on servers with
  specific collation has been fixed.

March 07, 2018

Active Query Builder History v.3.4.7.1084

= Sqlite: Keywords list has been filled.
= Full-featured demo projects: SQL Syntax detection and changing is 
  possible now for ODBC and OLE DB connections.
= Detection of installed OLE DB providers suitable to work with MS Access
  has been made.
= The new Expression Editor Demo has been added to the trial installation
  package.
= The General Demo has been renamed to Basic Demo.
- The bug with the stored procedure parameters retrieval on servers with
  specific collation has been fixed.
- Criteria Builder: The bug with creating filter items for empty general
  conditions has been fixed.
- SQL Text Editor: Minor suggestion list fixes have been made.

March 07, 2018

Active Query Builder History v.3.4.7.1084

= Sqlite: Keywords list has been filled.
= Full-featured demo projects: SQL Syntax detection and changing is 
  possible now for ODBC and OLE DB connections.
= Detection of installed OLE DB providers suitable to work with MS Access
  has been made.
= The new Expression Editor Demo has been added to the trial installation
  package.
= The General Demo has been renamed to Basic Demo.
- The bug with the stored procedure parameters retrieval on servers with
  specific collation has been fixed.
- Criteria Builder: The bug with creating filter items for empty general
  conditions has been fixed.
- SQL Text Editor: Minor suggestion list fixes have been made.
- Minor bugs and improvements in the Query Column List control have been
  made.

March 02, 2018

Active Query Builder History v.3.4.6.1083

= Parsing of incorrect/incomplete "IN" expressions in condition cells of 
  the Query Columns List has been improved.
= Logging of the stored procedure params loading has been improved.
= Scanners now use the /n symbol as a new-line symbol instead of /r.

March 02, 2018

Active Query Builder History v.3.4.6.1083

+ The new Expression Editor demo project has been added. It demonstrates
  the internal structure of the ExpressionEditor component.  
= SQL Text Editor: Minor auto-completion improvements have been made.
= Parsing of incorrect/incomplete "IN" expressions in condition cells of 
  the Query Columns List has been improved.
= Logging of the stored procedure params loading has been improved.
- The NullPointerException when leaving empty condition item in  the Query
  Columns List has been fixed.
- Expression Editor: Minor visual fixes and improvements have been made.