Downloads

Active Query Builder WinForms Edition History

March 02, 2012

Active Query Builder WinForms Edition v.1.16.6.355

- SQL Text Editor: The suggestion window did not hide on focus lost. Fixed now. 
  The new HideSuggestionWindow() method is added for it's manual hiding.
= More performance optimizations are made.

February 29, 2012

Active Query Builder WinForms Edition v.1.16.6.354

= Performance optimizations are made.
= More informative XML parsing exceptions (the inner exception is correctlty
  passed to AstException wrapper).
- SQL Text Editor: Wrong tooltip height when the control is hosted in WPF
  WindowsFormsHost is fixed.
- The problem with recursive CTE is fixed.
- Oracle: Parsing of expressions like "expression IN expression" is fixed.
- Oracle: Nested multiline comments were affecting the parsing. Fixed now.

February 28, 2012

Active Query Builder WinForms Edition v.1.16.5.353

+ SQL Text Editor: Text drag and drop is implemened.
+ SQL Text Editor: The new events are added: PreProcessKey, PostProcessKey,
  PreProcessMouseDown, PreProcessMouseMove, PreProcessMouseUp.

February 21, 2012

Active Query Builder WinForms Edition v.1.16.4.352

- SQL Text Editor: The exception on showing Find dialog when the control is hosted 
  in WPF window is fixed.

February 20, 2012

Active Query Builder WinForms Edition v.1.16.4.351

- Oracle: Parsing of TABLE function is fixed.
- MySQL: Parsing of logical expressions in criteria cells is fixed.
- Changing of the QuoteAllIdentifiers and ObjectPrefixSkipping properties does 
  not clear the query any more.
= QueryStatistics.OutputColumns[i].ColumnName is always unquoted now.

February 14, 2012

Active Query Builder WinForms Edition v.1.16.4.350

- DevExpressControlFactory: The CriteriaListOptions.CriteriaListFont property did
  not affect the DevExpressCriteriaListControl font. Fixed now.
- DevExpressControlFactory: Automatic alias generation when adding fields with
  same names is fixed.

February 10, 2012

Active Query Builder WinForms Edition v.1.16.4.349

+ Field alias is used now as tab caption for expression sub-queries that are used
  as fields in the parent query. 
- DevExpressControlFactory: The Union button size and location is fixed.

February 09, 2012

Active Query Builder WinForms Edition v.1.16.4.348

+ The new syntax provider for Microsoft SQL Azure databases is added.
  (MSSQLAzureSyntaxProvider)
= SQL Text Editor: The methods to show Find/Replace dialogs are made public:
  ShowFindDialog(), ShowFindAndReplaceDialog().
= Expression Editor: The "Active sub-query" and "Metadata" tabs are swapped; 
  "Active sub-query" tab is renamed to "Query Objects". 
- Some synchronization issues of the SyncSQL property revealed in WPF
  applications are fixed.

February 06, 2012

Active Query Builder WinForms Edition v.1.16.3.346

= MS SQL Server: Now FOR XML clause can be used in subqueries too.
= Firebird: The new aggregate function LIST, WEEKDAY and YEARDAY keywords in
  EXTRACT function are added.
- The minor issue in parsing of ORDER BY clause of simple queries is fixed.
- MySQL, PostgreSQL: Loading of column precision and scale from server system
  catalogs is fixed.
- MySQL: Parsing of sub-queries in criteria cells is fixed.
- Loading of stored procedure fields is fixed.

February 02, 2012

Active Query Builder WinForms Edition v.1.16.3.345

+ SQL Text Editor and Expression Editor can be localized now using the
  QueryBuilder's Language property and its language files. The new strings to
  localize are added to the "en.xml".
= The double click on a field in a data source adds new item to the query
  columns list without marking it selected for output now.
- Synchronization issues on using the QueryBuilder.SyncSQL property in the Leave
  event of a text box are fixed.
- SQL Text Editor: Line numbers are updated properly now on the Enter key press.
- Resizing of CTE datasource located in a hidden tab when changing it's field
  list is fixed.