Downloads

Active Query Builder 3 WinForms Edition History

December 22, 2018

Active Query Builder 3 WinForms Edition v.3.5.9.1116

= Mistyped or incomplete conditions detection has been improved.
= VistaDB: References to the client library is updated to the latest
  version.

December 13, 2018

Active Query Builder 3 WinForms Edition v.3.5.8.1115

= SQL text generation and parsing have been speeded up. 
- PostgreSQL: Parsing ambiguities for INTERVAL and AT TIME ZONE have been
  eliminated. 
- DevExpress: The bug with SQL expression property editor has been fixed.
- The notification about SQL expression errors in conditions has been
  corrected.

November 29, 2018

Active Query Builder 3 WinForms Edition v.3.5.6.1113

= Main localizations have been updated.
+ MS SQL Server: Support for SQL 2017 specific syntax of CONCAT_WS,
  TRANSLATE, and TRIM functions and query hints has been added.
- Stored procedure parameter values validation in the Properties bar has
  been fixed.
- The bug with disposing of custom Query Column List Control cells has 
  been fixed.

November 26, 2018

Active Query Builder 3 WinForms Edition v.3.5.6.1112

= References to DevExpress assemblies are updated to version 18.2.
= MS SQL Server: Column aliases for functions are allowed now.
- The Add Object dialog has been fixed.
- The problem with join expressions in the WHERE clause in correlated
  subqueries has been fixed.
- SQL Text Editor: Caret positioning by mouse has been made more accurate.
- The notification about errors in Criteria expressions has been fixed.

November 03, 2018

Active Query Builder 3 WinForms Edition v.3.5.5.1111

- Memory leaks for undisposed AstNode objects have been eliminated. Took 
  place when you have a long-life SQLContext object and use it to process
  multiple SQLQuery objects.
- DevExpress: The source code to compile the DevExpress GUI assembly has 
  been corrected.

November 01, 2018

Active Query Builder 3 WinForms Edition v.3.5.5.1110

+ The new DatabaseSchemaViewOptions.DefaultExpandFolderNodes property has
  been added to control the initial expansion of nodes which aren't tied 
  to a specific MetadataItem object. Default value: False.
= An error is displayed now in Properties dialogs preventing the dialog
  close on clicking the OK button when incorrect SQL expression is entered
  for one of the properties.
= Query Columns List: The Shift+F2 shortcut is added now to call the
  Expression Editor in Expression and Criteria cells.
= Query Column List: The Alt+Down shortcut now opens drop-down list in
  appropriate cells.
- Minor Properties Bar fixes have been made, Tab key navigation has been
  fixed.
- Emptying Link Expression now results in displaying a specific error
  message.
- SQL Text Editor: Appliance of the font to the suggestion window has been
  fixed.
- SQL Text Editor: The Replace text functionality is back.
- The problem with a black rectangle at the bottom of datasources on the
  Design Pane has been fixed.
- MS SQL Server: The bug with retrieving primary key when a table contains
  Clustered Index has been fixed.
- PostgreSQL: Parsing of the AT TIME ZONE operator has been fixed.
- Memory leaks when QueryBuilder component hasn't disposed have been
  eliminated.

October 18, 2018

Active Query Builder 3 WinForms Edition v.3.5.4.1109

- The regression in the case of the Database Schema Tree re-initialization 
  introduced in the previous build has been eliminated.

October 17, 2018

Active Query Builder 3 WinForms Edition v.3.5.4.1108

- The bug with applying the DefaultExpandMetadataType property on 
  initializing the Database Schema Tree has been fixed.
- SQL Text Editor: The bug with positioning the cursor by mouse in the case
  of the large text padding has been fixed.
- The collapse search panel button style has been reverted to the previous
  style.
- The bug with localizing context menu in the Reusable Queries View has been
  fixed.

October 15, 2018

Active Query Builder 3 WinForms Edition v.3.5.4.1107

+ DevExpress: Full support of skins, including dark themes. All custom
  controls now obey skin colors.
+ MySQL: Support for Common Table Expressions in MySQL 8+ has been made.
= Reusable queries: Users now can save to repository even those queries
  which cannot be used in further queries due to the limitation of specific
  SQL syntax (presence of CTE, etc).
- Oracle: Support for ranking functions has been improved.
- PostgreSQL: The bug with "EXTRACT(epoch FROM ...)" function has been 
  fixed.
- MS Access: The bug with TRUE and FALSE constants parsing has been fixed.
- Sizes of datasources are restored correctly now via the LayoutSQL
  property.
- The bug with the expanding/collapsing of datasource search panel has been
  fixed.
- The bug with the incorrect behaviour of the
  DataSourceOptions.CheckboxesVisible property has been fixed.

September 19, 2018

Active Query Builder 3 WinForms Edition v.3.5.3.1106

= Deletion confirmation dialog has been beautified.
= Filter Item control: "OK" and "Cancel" buttons have been added.
= Standard version demos: The editor for the DefaultExpandMetadataType has
  been added to the Properties form.
= DevExpress: Theme colors are applied correctly to Properties sidebar now.
- DevExpress: Properties bar: The properties container growing has been
  fixed.
- Properties bar: The missing Criteria column has been restored in the 
  Query Column List properties editor.
- Properties bar: Boolean editor cropping fixed.
- Properties bar: Showing/hiding and resizing descriptions has been fixed.
- MS SQL Server: The bug with disabled editors for "Percent" and "With ties"
  properties has been fixed.
- Query Columns List: Appliance of the default width to "Or" columns has
  been fixed.
- The bug with duplication of the column list for objects in the query 
  which weren't uniquely identified has been fixed.
- OLE DB Metadata Provider: Loading of the PrimaryKey flag from the Indexes
  collection has been fixed.
- Multi-thread concurrent execution issue has been fixed.