Downloads

Active Query Builder History History

December 09, 2016

Active Query Builder History v.3.2.1.1032

= PostgreSQL Metadata Provider: Reference to Npgsql has been updated.
- Displaying of Varchar(Max) and Varbinary(Max) data types in the datasource
  fields list has been fixed.
- MS SQL Server: List of valid identifiers has been updated.
- SQLite: Support for the string concatenation operator ("||") is fixed.

December 09, 2016

Active Query Builder History v.3.2.1.1032

= PostgreSQL Metadata Provider: Reference to Npgsql has been updated.
- Control crash when clearing the text and checking the asterisk item ("*")
  on the table has been fixed.
- Displaying of Varchar(Max) and Varbinary(Max) data types in the datasource
  fields list has been fixed.
= The bug not allowing to use Custom Expression Builder or Expression Editor
  for both the Expression and Criteria columns has been fixed.
- MS SQL Server: List of valid identifiers has been updated.
- SQLite: Support for the string concatenation operator ("||") is fixed.
- Demo projects have been fixed.

December 09, 2016

Active Query Builder History v.3.2.1.1032

= PostgreSQL Metadata Provider: Reference to Npgsql has been updated.
- Control crash when clearing the text and checking the asterisk item ("*")
  on the table has been fixed.
- Displaying of Varchar(Max) and Varbinary(Max) data types in the datasource
  fields list has been fixed.
= The bug not allowing to use Custom Expression Builder or Expression Editor
  for both the Expression and Criteria columns has been fixed.
- MS SQL Server: List of valid identifiers has been updated.
- SQLite: Support for the string concatenation operator ("||") is fixed.
- Demo projects have been fixed.

December 08, 2016

Active Query Builder History v.2.10.5.795

- Firebird: Support of the simple form of TRIM function has been fixed.
- Oracle: Support for the special form of TRIM function has been fixed.
- Displaying of Varchar(Max) and Varbinary(Max) data types in the datasource
  fields list has been fixed.
- Calculation of checked fields in the datasource fields list has been
  fixed.
- Parsing of the single-line comments has been fixed.
- MS SQL Server: List of valid identifiers has been updated.
- SQLite: Support for the string concatenation operator ("||") is fixed.

December 08, 2016

Active Query Builder History v.1.26.30

+ The new IActiveQueryBuilderX.PartialMetadataLoading property has been
  added. Setting it to True prescribes the component to load metadata only
  for objects that were used in the query on assigning it to the SQL
  property. 
+ Mouse wheel works now in pick up lists of the Query Columns Grid.
+ The MetadataContainer.LoadFromXML method is significantly speeded up.
- Firebird: Support of aliases in the ORDER BY clause only for the version
  2.0 and higher.
- MS SQL Server: List of valid identifiers list has been updated.
- Single-line comments are recognized properly now.

December 08, 2016

Active Query Builder History v.1.26.30

+ The new TacQueryBuilder.PartialMetadataLoading property has been added.
  Setting it to True prescribes the component to load metadata only for
  objects that were used in the query on assigning it to the SQL property. 
  You shouldn't call the RefreshMetadata method in this mode.
+ Mouse wheel works now in pick up lists of the Query Columns Grid.
+ The MetadataContainer.LoadFromXML method is significantly speeded up.
- Firebird: Support of aliases in the ORDER BY clause only for the version
  2.0 and higher.
- Demo app: The parameters form for ADO connection has been fixed.
- MS SQL Server: List of valid identifiers list has been updated.
- Single-line comments are recognized properly now.

November 25, 2016

Active Query Builder History v.3.2.1.1031

+ Ability to work with CTE within the Sub-query navigation bar has been made. 
  Users can add, remove, reorder CTE and drag them to the Design Pane.
+ The DISTINCT option has been added to the Properties bar for Generic and
  ANSI SQL dialects.
+ CTE name can be changed now using the Properties bar.
= Double-click on a field in the datasource fields list now leads to the 
  addition of a new unchecked item to the Query Columns List. Focus is moved 
  to the Criteria column to add condition for a newly added item.
= Default configuration of sidebar panels have been changed.
= New labels can be localized now.
- Minor bugfixes and improvements have been made.

November 25, 2016

Active Query Builder History v.3.2.1.1031

+ Ability to work with CTE within the Sub-query navigation bar has been made. 
  Users can add, remove, reorder CTE and drag them to the Design Pane.
+ The DISTINCT option has been added to the Properties bar for Generic and
  ANSI SQL dialects.
+ CTE name can be changed now using the Properties bar.
= Double-click on a field in the datasource fields list now leads to the 
  addition of a new unchecked item to the Query Columns List. Focus is moved 
  to the Criteria column to add condition for a newly added item.
= Default configuration of sidebar panels have been changed.
= New labels can be localized now.
- Minor bugfixes and improvements have been made.

November 25, 2016

Active Query Builder History v.3.2.1.1031

- Access: parsing Excel sheet names with dollar sign is fixed

November 23, 2016

Active Query Builder History v.1.26.29

+ Scrolling by mouse wheel now works in the drop-down pick list of the
  Expression cell editor.
= The FieldListDescriptionColumnOptions.ShowLongDescription property is 
  now set to True by default.
= Minor column type painting improvements in datasource field lists have
  been made.
- Calculation of checked fields in datasource field lists has been fixed.
- The Varchar(Max) and Varbinary(Max) types are displayed correctly now.
- MS Jet: Excel sheet names with the dollar sign are supported now.
- Oracle: Support for the special form of TRIM function has been added. 
- MS SQL Server: ROW and ROWS are added to the list of valid identifiers.
- Other minor bugfixes and improvements have been made.