Downloads

Active Query Builder History History

December 27, 2013

Active Query Builder History v.1.1.3

- The bug with sorting items in Database Schema Tree is fixed.

December 20, 2013

Active Query Builder History v.2.6.1.618

+ The new PaintDesignPaneToBitmap() method is added for exporting the design pane
  content to an image.

December 19, 2013

Active Query Builder History v.1.22.6

= Windows 2000 compatible version is added to the "Compat" folder.
= Required stack size for SQL parsing is reduced.
= Custom popup menu is used for all Query Columns Grid cells now.
= The RightToLeft mode is turned off for expressions in the Query Columns Grid. 
- Minor localization updates are made.
= MS SQL Server: SQL parser is optimized to speed up parsing of deep nested
  function calls.
= MS SQL Server: PARSE is treated as valid identifier now.
- MS SQL Server: Server version autodetection is fixed.
= MS Access: Date/time builtin functions are supported.

December 19, 2013

Active Query Builder History v.1.22.6

= Required stack size for SQL parsing is reduced.
= Custom popup menu is used for all Query Columns Grid cells now.
= The RightToLeft mode is turned off for expressions in the Query Columns Grid. 
- Minor localization updates are made.
- The bug with loading empty string from localization in non-unicode Delphi 
  versions is fixed.
= MS SQL Server: SQL parser is optimized to speed up parsing of deep nested
  function calls.
= MS SQL Server: PARSE is treated as valid identifier now.
- MS SQL Server: Server version autodetection is fixed.
= MS Access: Date/time builtin functions are supported.

December 11, 2013

Active Query Builder History v.1.1.2

- Compatibility with Microsoft .NET 4.0 Framework JavaScript is restored.

December 10, 2013

Active Query Builder History v.1.1.1

+ The bug with reformatting date/time values in Criteria Builder is fixed.
+ The new Grid.QuickFilterInExpressionMatchFromBeginning property is added.
+ Minor GUI fixes are made.

December 06, 2013

Active Query Builder History v.2.6.0.617

= The icon for referencing objects menu item has been changed.
- Recursion loop detection on building result SQL with virtual fields is made.
- Oracle: The schema loading query is corrected to load schemas that have no
  tables, but contain other types of database objects.
- Query Transformer: Filters were applied incorrectly to wrapped queries.
  Fixed now.

December 05, 2013

Active Query Builder History v.1.7.0.1134

+ The new button is now shown at the right of the focused datasource on Design
  pane to allow easy adding of linked objects to the query. The feature is also
  available from the datasource context menu.
+ The new ShowLinkedObjectsButton property is addeed.
- Auto-detection of Teradata and SQL CE servers is fixed.
- Loading of WHERE joins with subqueries referencing other datasources is fixed.
- PostgreSQL: Support for AT TIME ZONE expression, ROW constructor expression,
  and ORDER BY in aggregate functions is fixed.
- MS SQL Server: "PARSE" is a valid identifier now.
- MS SQL Server: The conflict between "char" and "nchar" identifiers and 
  same-named built-in functions is eliminated.
= MS SQL Server: Parsing of nested function calls is speeded up.

November 28, 2013

Active Query Builder History v.1.19.4.434

= References to DevExpress controls are updated to v.13.1.8.0.
- Tab order in Datasource Properties form is fixed.
- Auto-detection of Teradata, MS SQL CE and Azure database servers is fixed.
- Loading of joins in WHERE clause with subqueries referencing other
  datasources is fixed.
- Check boxes painting at non-standard display resolution settings 
  (120 DPI and more) is fixed.
- Expression Editor: The bug with ShowSuggestionAfterCharCount property 
  causing problems in the Form designer is fixed.
- SQL Text Editor: Backward search from the end of text is fixed.
- Oracle: Keywords UNTIL and UPDATED can be used as identifiers.
- Oracle: Fixed MODEL clause.
- Oracle: Support for KEEP expression is added.
- Oracle: Parsing of PARTITON with OUTER JOIN is fixed.
- PostgreSQL: Support for AT TIME ZONE expression is made.
- PostgreSQL: Support for the ROW constructor expression is made.
- PostgreSQL: The EXTRACT function is fixed.
- PostgreSQL: Support for ORDER BY in aggregate functions is added.
- MS SQL Server: "PARSE" is valid identifier now.
- MS SQL Server: The conflict between "char", "nchar" identifiers and 
  same-named built-in functions is solved.
= MS SQL Server: Parsing of nested function calls is optimized for speed.

November 26, 2013

Active Query Builder History v.2.6.0.616

! The bug with broken ReferencedObject name in ForeignKey is fixed.
= Items in the Linked Objects menu now sorted alphabetically.
- Loading of joins in WHERE clause with subqueries referencing other
  datasources is fixed.
- PostgreSQL: Support for ORDER BY in aggregate functions is added.
- MS SQL Server: "PARSE" is valid identifier now.
- MS SQL Server: The conflict between "char", "nchar" identifiers and 
  same-named built-in functions is solved.
= MS SQL Server: Parsing of nested function calls is optimized for speed.