Downloads

Active Query Builder 3 WinForms Edition History

May 08, 2018

Active Query Builder 3 WinForms Edition v.3.4.13.1090

+ The new method is available now in the SQLQuery service to link a newly
  added object to other objects having same named fields.
  The LinkObjectBySameNamedFields accepts a DataSource as a parameter and
  returns a list of newly added Link objects.
- The bug with metadata filtration arising in some particular cases has been
  fixed.
- The Remove context menu item is not displayed for sub-queries in
  expressions.
- The "Image index out of range" error has been fixed.

May 04, 2018

Active Query Builder 3 WinForms Edition v.3.4.12.1089

= SQL Text Editor: The first item in suggestion window is not selected now
  right after its opening. This eliminates the problem of unnecessary
  substitutions.

April 23, 2018

Active Query Builder 3 WinForms Edition v.3.4.11.1088

+ Pervasive: Support for Pervasive PSQL (Actian Zen) has been added.

April 14, 2018

Active Query Builder 3 WinForms Edition v.3.4.10.1087

+ The new method SubQuery.GetSqlForDataPreview has been added to retrieve
  the text of sub-query along with the referred named queries from the
  Common Table Expression to organize data preview for sub-queries.
+ Full-featured demos now use the GetSqlForDataPreview method for data
  preview.
+ The new CTEUnitVisible, UnionsUnitVisible properties have been added to
  the SubQueryNavBar and QueryNavigationBar controls.
- Minor bug fixes and improvements have been made.

April 09, 2018

Active Query Builder 3 WinForms Edition v.3.4.9.1086

- SQL Text Editor: The bug with incorrect word wrapping has been fixed.
- SQLite: Parsing of queries with RIGHT and FULL joins now results in the
  parsing error.
- The bug with black cell background in the Query Column List Control has
  been fixed.
- IBM DB2: NULL is parsed now as a constant, not as an identifier.
- MS SQL Server: Parsing of qualified names with skipped components has 
  been fixed.
- MS SQL Server: Loading of fields for linked servers without database or
  schema has been fixed.

April 02, 2018

Active Query Builder 3 WinForms Edition v.3.4.8.1085

+ The new property DataSourceOptions.CheckboxesVisible lets turn off
  checkboxes in datasource field lists.
= Expression Editor: Focus is now set into the text editor after insertion
  from suggestion lists.
- Native and DevExpress controls scaling issues have been fixed.

March 07, 2018

Active Query Builder 3 WinForms Edition v.3.4.7.1084

= Sqlite: Keywords list has been filled.
= Full-featured demo projects: SQL Syntax detection and changing is 
  possible now for ODBC and OLE DB connections.
= Detection of installed OLE DB providers suitable to work with MS Access
  has been made.
= The new Expression Editor Demo has been added to the trial installation
  package.
= The General Demo has been renamed to Basic Demo.
- The bug with the stored procedure parameters retrieval on servers with
  specific collation has been fixed.
- Criteria Builder: The bug with creating filter items for empty general
  conditions has been fixed.
- SQL Text Editor: Minor suggestion list fixes have been made.

March 02, 2018

Active Query Builder 3 WinForms Edition v.3.4.6.1083

+ The new Expression Editor demo project has been added. It demonstrates
  the internal structure of the ExpressionEditor component.  
= SQL Text Editor: Minor auto-completion improvements have been made.
= Parsing of incorrect/incomplete "IN" expressions in condition cells of 
  the Query Columns List has been improved.
= Logging of the stored procedure params loading has been improved.
- The NullPointerException when leaving empty condition item in  the Query
  Columns List has been fixed.
- Expression Editor: Minor visual fixes and improvements have been made.

February 19, 2018

Active Query Builder 3 WinForms Edition v.3.4.5.1082

- Minor fixes have been made.

February 17, 2018

Active Query Builder 3 WinForms Edition v.3.4.5.1081

= The new field QueryColumnListControl.HitTest.ConditionIndex has been added. 
  It allows determining the corresponding item in the query object model.
- Criteria Builder: Minor fixes and improvements have been made.
- SQL Text Editor: The bug with deleting the text next to a parenthesis has 
  been fixed.
- Bounds and collapsed state in the layout data are saved correctly now.
- Metadata Structure: The bug with grouping items by database object type has
  been fixed.
- Teradata: Addition of datasources to design pane has been speeded up.
- MySQL: Support of STDDEV function has been fixed.
- Custom context menu is displayed now for condition cells of the 
  Query Columns Grid.
- DevExpress: Cell context menu is now displayed in the proper position.