Downloads

Active Query Builder History History

March 02, 2016

Active Query Builder History v.3.0.3.1007

+ Non-Visual Demo is added.
- StatisticsOutputColumn: Origin* properties calculation for CTE is fixed.
- Add Object Dialog: Filter button is fixed.
- Database Schema View: Loading of large database schema is speeded up.
- Query Column List Control: Exception is fixed.
- Query Column List Control: Ellipsis button of the last row is fixed.

March 02, 2016

Active Query Builder History v.1.26.16

+ The new property IActiveQueryBuilderX.TableWidthMode is added to determine
  width of new datasources on Design Pane. Possible values:
  twmFixed=0 - fixed, specifed by the DefaultTableWidth property,
  twmAutosizeByContent=1 - calculated to fit the while text content,
  twmAutosizeByFieldName=2 - calculated to fit the longest field name.
- Hanging on exit in case of ODBC connection is fixed now.
- The bug with empty fields list in case of ODBC connection is fixed.
- Query Column List control: The "Sort Type" column autosize is fixed.

March 02, 2016

Active Query Builder History v.1.26.16

+ The new property TacQueryBuilder.DatasourceOptions.TableWidthMode is added
  to determine width of new datasources on Design Pane. Possible values:
  twmFixed - fixed, specifed by the DefaultTableWidth property,
  twmAutosizeByContent - calculated to fit the while text content,
  twmAutosizeByFieldName - calculated to fit the longest field name.
- FireDAC, AnyDAC 2: CmdExecTimeout setting is fixed.
- Query Column List control: The "Sort Type" column autosize is fixed.

February 29, 2016

Active Query Builder History v.2.10.12

= The UnionSubQuery methods to get parts of the SQL text are published:
  GetSelectClauseString, GetFromClauseString, etc.

February 25, 2016

Active Query Builder History v.2.10.11

- The bug with sorting objects in the Database Schema View in Offline mode 
  is fixed.

February 20, 2016

Active Query Builder History v.2.10.10

- The bug with unsorted items on tree levels higher than the value of
  DefaultExpandLevel property is fixed.
- The bug with non-collapsible metadata items in the tree is fixed.
- The bug with actions taken place after loosing of ASP session is fixed.
+ Query Statistics: New properties are added to the StatisticsOutputColumn
  class to ease determination of origin of a column in case it comes from
  derived table or CTE: OriginDatasource, OriginMetadataObject and
  OriginMetadataField.
= MS SQL Server: Parsing performance is improved.
- MS SQL: "COLLATE" reserved word after the column expression is allowed.
- Firebird: Generation of the FIRST and SKIP clauses by QueryTransformer
  is fixed.

February 20, 2016

Active Query Builder History v.2.10.5.760

+ Query Statistics: New properties are added to the StatisticsOutputColumn
  class to ease determination of origin of a column in case it comes from
  derived table or CTE: OriginDatasource, OriginMetadataObject and
  OriginMetadataField.
- Metadata Structure: Custom field nodes in the database schema tree are
  fixed now.
- Setter of the QueryColumnListItem.SortOrder property is fixed.
= MS SQL Server: Parsing performance is improved.
- MS SQL: "COLLATE" reserved word after the column expression is allowed.
- Firebird: Generation of the FIRST and SKIP clauses by QueryTransformer
  is fixed.

February 20, 2016

Active Query Builder History v.3.0.2.1006

+ Query Statistics: New properties are added to the StatisticsOutputColumn
  class to ease determination of origin of a column in case it comes from
  derived table or CTE: OriginDatasource, OriginMetadataObject and
  OriginMetadataField.
- Metadata Structure: Custom field nodes in the database schema tree are
  fixed now.
- Setter of the QueryColumnListItem.SortOrder property is fixed.
= MS SQL Server: Parsing performance is improved.
- MS SQL: "COLLATE" reserved word after the column expression is allowed.
- Firebird: Generation of the FIRST and SKIP clauses by QueryTransformer
  is fixed.
+ BaseSyntaxProvider: The new server capability flag is added for future SQL 
  syntaxes: support of aliases in GROUP BY clause (IsSupportGroupByAlias).
= Default value of the DatabaseSchemaViewOptions.SortingType property is 
  changed to NameExceptFields.
= QueryColumnList: Ellipsis button in expression and condition columns is 
  always shown now. It displays item context menu.
- SQL Text Editor:  Incorrect behavior on pressing Ctrl-Right keys at the end 
  of the text is fixed now.
- TextEditor: The error on pressing Ctrl-Up and Ctrl-Down keys is fixed.
- Other minor bugs are fixed.

February 20, 2016

Active Query Builder History v.3.0.2.1006

+ Query Statistics: New properties are added to the StatisticsOutputColumn
  class to ease determination of origin of a column in case it comes from
  derived table or CTE: OriginDatasource, OriginMetadataObject and
  OriginMetadataField.
- Metadata Structure: Custom field nodes in the database schema tree are
  fixed now.
- Setter of the QueryColumnListItem.SortOrder property is fixed.
= MS SQL Server: Parsing performance is improved.
- MS SQL: "COLLATE" reserved word after the column expression is allowed.
- Firebird: Generation of the FIRST and SKIP clauses by QueryTransformer
  is fixed.
+ BaseSyntaxProvider: The new server capability flag is added for future SQL 
  syntaxes: support of aliases in GROUP BY clause (IsSupportGroupByAlias).
= Default value of the DatabaseSchemaViewOptions.SortingType property is 
  changed to NameExceptFields.
= QueryColumnList: Ellipsis button in expression and condition columns is 
  always shown now. It displays item context menu.
- SQL Text Editor:  Incorrect behavior on pressing Ctrl-Right keys at the end 
  of the text is fixed now.
- TextEditor: The error on pressing Ctrl-Up and Ctrl-Down keys is fixed.
- Other minor bugs are fixed.

February 20, 2016

Active Query Builder History v.1.26.15

= MS SQL Server: Parsing performance is improved.
- The SelectList.SortOrder setting is fixed.
- Query Columns List: The fix for "Aggregate" and "Grouping" columns
  auto-fit is made.