Downloads

Active Query Builder History History

January 27, 2018

Active Query Builder History v.1.28.4

= Index numbers in ORDER BY are converted to corresponding expressions now.
= PostgreSQL parser has been optimized.
- DB2: Parsing of FOR UPDATE, FOR READ ONLY, ISOLATION and OPTIMIZE FOR in
  an arbitrary order has been fixed.
- Oracle, MySQL, MS SQL Server: Several SQL parsing fixes have been made.
= ODBC: Fetching of databases and schemas is supported now.

January 26, 2018

Active Query Builder History v.3.4.3.1078

! SubQuery: Setting the LimitCount and LimitOffset properties is temporarily
  turned off.
- The ConditionalOperatorsFormat.NewLineBeforeWhen property has been fixed.
= PostgreSQL parser has been optimized.

January 26, 2018

Active Query Builder History v.3.4.3.1078

+ Tooltip on the datasource caption is now displaying the description for
  database objects or the beginning of sub-query text for sub-queries.
= Expression Editor: The SQLFormattingOptions is a reference property now,
  not a contained object.
! SubQuery: Setting the LimitCount and LimitOffset properties is temporarily
  turned off.
- Search in the Database Schema View with custom metadata structure has been
  fixed.
- Sub-queries from the "IN (SELECT ...)" conditions are displayed on the
  Query Navigation Bar now.
- The ConditionalOperatorsFormat.NewLineBeforeWhen property has been fixed.
= PostgreSQL parser has been optimized.
- Several minor bugs have been fixed.

January 26, 2018

Active Query Builder History v.3.4.3.1078

+ Tooltip on datasource caption displaying the description for database
  object or the beginning of sub-query text for sub-queries.
= It is now possible ability to resize datasources on Design Pane by
  dragging their left and top borders.
- The bug with eating the first mouse click on the Design Pane has been
  fixed.
= Expression Editor: The SQLFormattingOptions is a reference property now,
  not a contained object.
! SubQuery: Setting the LimitCount and LimitOffset properties is temporarily
  turned off.
- The bug on clicking the suggestion window hint has been fixed.
- Search in the Database Schema View with custom metadata structure has been
  fixed.
- Sub-queries from the "IN (SELECT ...)" conditions are displayed on the
  Query Navigation Bar now.
- The ConditionalOperatorsFormat.NewLineBeforeWhen property has been fixed.
= PostgreSQL parser has been optimized.
- Several minor bugs have been fixed.

January 25, 2018

Active Query Builder History v.3.0.3

+ The ability to edit text of sub-queries separately from the entire query 
  has been made. Read the Knowledge Base article at
  https://support.activequerybuilder.com/hc/en-us/articles/360000148009
  and review the Edit Sub-Query Text Demo project.
+ The new SqlEditor.TargetQueryPart property has been added. It accepts the 
  Query, SubQuery and UnionSubQuery values.
+ The new QueryBuilder.ActiveUnionSubQueryChanged event has been added.
+ The new activeSubQuerySQL and activeUnionSubQuerySQL properties have been 
  added to the AQB.Web.QueryBuider object on the client.
+ The new addNewNamedSubQuery, addDerivedTable, addUnionSubQuery methods 
  have been added to the AQB.Web.QueryBuilder object to make possible
  execute these commands from JavaScript. 
+ The new AQB.Web.QueryBuilder.dispose method destroys the QueryBuilder
  object both on the server and client.
- The bug with displaying field name instead of column alias has been
  fixed.
- The bug with the design pane context menu has been fixed.
- Localization of the Properties forms has been fixed.
- Z-index for some HTML elements has been corrected.
= Resource packing and caching has been made.
+ The new configuration property EnableResourceCaching has been added.

January 24, 2018

Active Query Builder History v.2.10.12.820

+ Sybase: Support for window functions has been added.
= Numeric constants in ORDER BY are converted to corresponding expressions now.
- DB2: Parsing of FOR UPDATE, FOR READ ONLY, ISOLATION and OPTIMIZE FOR in
  an arbitrary order has been fixed.
+ Oracle: Loading of stored procedure parameters from the server system
  catalog is supported now.
- Oracle, MySQL, MS SQL Server: Several SQL parsing fixes have been made.

January 22, 2018

Active Query Builder History v.3.4.2.1077

= Numeric constants in ORDER BY are converted to corresponding expressions now.
- Numerous fixes and improvements to the Query Properties Bar and SQL Text 
  Editor have been made.
+ Oracle: Loading of stored procedure parameters from the server system 
  catalog is supported now.
- Oracle, MySQL, MS SQL Server: Several SQL parsing fixes have been made.

January 22, 2018

Active Query Builder History v.3.4.2.1077

+ Better visual style for the database schema tree has been made.
+ The new property QueryBuilder.DatabaseSchemaViewOptions.DrawTreeLines
  controls drawing of tree lines between nodes of the database schema tree.
+ The component is now asking for deleting sub-queries. 
= Various SQL expression error reporting improvements have been made.
+ The new UserInterfaceOptions property group has been added to the
  QueryView and QueryBuilder classes.
  The QueryBuilder.UserInterfaceOptions.ConfirmSubQueryDeletion property
  prescribes to display the confirmation dialog on deleting a sub-query.
  The QueryBuilder.UserInterfaceOptions.WarnAboutSQLExpressionErrors 
  property instructs to display popup window when the user makes a syntax
  error in SQL expression.
+ Expression Editor: SQL expressions are formatted now according to the 
  settings of the new SQLFormattingOptions property.
= Expression Editor: Monospace font is used by default now.
= Index numbers in ORDER BY are converted to corresponding expressions now.
- Numerous fixes and improvements to the Query Properties Bar and SQL Text 
  Editor have been made.
+ Oracle: Loading of stored procedure parameters from the server system 
  catalog is supported now.
- Oracle, MySQL, MS SQL Server: Several SQL parsing fixes have been made.
= New and missing localizable strings have been added.
- Localization fixes have been made.

January 22, 2018

Active Query Builder History v.3.4.2.1077

+ The new property QueryBuilder.DatabaseSchemaViewOptions.DrawTreeLines
  controls drawing of tree lines between nodes of the database schema tree.
+ The component is now asking for deleting sub-queries. 
= Various SQL expression error reporting improvements have been made.
+ The new UserInterfaceOptions property group has been added to the 
  QueryView and QueryBuilder classes.
  The QueryBuilder.UserInterfaceOptions.ConfirmSubQueryDeletion property
  prescribes to display the confirmation dialog on deleting a sub-query.
  The QueryBuilder.UserInterfaceOptions.WarnAboutSQLExpressionErrors 
  property instructs to display popup window when the user makes a syntax
  error in SQL expression.
+ Expression Editor: SQL expressions are formatted now according to the 
  settings of the new SQLFormattingOptions property.
= Expression Editor: Monospace font is used by default now.
= Index numbers in ORDER BY are converted to corresponding expressions now.
- Numerous fixes and improvements to the Query Properties Bar and SQL Text 
  Editor have been made.
+ Oracle: Loading of stored procedure parameters from the server system 
  catalog is supported now.
- Oracle, MySQL, MS SQL Server: Several SQL parsing fixes have been made.
= New and missing localizable strings have been added.
- Localization fixes have been made.

January 12, 2018

Active Query Builder History v.3.4.1.1076

= SubQuery.Caption property returns localized caption for the main query.
= Default namespaces aren't shown in datasource captions now.
- Metadata Structure: Grouping by types at the top level has been fixed.
= Only the simple WHERE clause conditions like "field1 = field2" are loaded as links now.
- Generation of offset in the LIMIT expression has been fixed.
- Loading of reusable queries has been fixed.