Downloads  »  Active Query Builder VCL Edition History

December 13, 2019

Active Query Builder VCL Edition v.1.30.0

Below is the list of fixes and improvements in Active Query Builder VCL Edition v.1.30.0.

Standard edition:
+ The new component TacSQLScript splits the query by statements, allows to 
  look through them and edit separate statements in it.
+ The new TacQueryParametersTransformer component is added to: 
  1. cut off conditions with undefined parameter values, 
  2. convert parameter notation to the colon-prefixed notation.
= Query Columns List: Handling of incomplete strings in expression cells 
  has been improved.
- PostgreSQL: Support for WITH clause in subqueries has been added.

Professional version:
+ The new TacQueryParametersTransformer is also capable to deal with macros.
  Using it you can replace a single parameter with a list of values, SQL 
  expression or sub-query. 
+ SQL Text Editor: The suggestion list now works smoothly, filters items to
  suggest smarter and loads the needed metadata in a thread. 
+ SQL Text Editor: New properties have been added to tune colors and 
  suggestion behavior.
+ SQL Text Editor: Highlights the current SQL statement and provides methods
  to get and set the current SQL statement.
= SQL Text Editor: Other fixes and usability improvements have been made.

[           Legend:          ]
[ + New feature              ]
[ = Improved/changed feature ]
[ - Bug fix                  ]
[ ! Important notice         ]

You can always get the latest trial version of Active Query Builder VCL Edition at the download page.

» Full Active Query Builder VCL Edition history