Downloads

Active Query Builder WinForms Edition History

January 30, 2012

Active Query Builder WinForms Edition v.1.16.2.344

+ SQL Text Editor: The ReadOnly property is added.

January 27, 2012

Active Query Builder WinForms Edition v.1.16.2.343

+ SQL Text Editor: Text find and replace features with dialogs are made.
  Available shortcuts:
  Ctrl-F3  - Quick find the selected word or a word under cursor.
  F3       - Find next.
  Shift-F3 - Find previous.
  Ctrl-F   - Show Find Dialog.
  Ctrl-H   - Show Find and Replace Dialog.
+ Sql Text Editor: The ShowLineNumbers property is made to show line numbers :).
+ Expression Editor: Active sub-query object list is added.
- Expression Editor: The Enter key press in the object and function lists was
  acting like the default OK dialog button. Fixed now.
- The exception on query statistics generation when the query builder is in the
  SleepMode is fixed.

December 30, 2011

Active Query Builder WinForms Edition v.1.16.1.342

+ Expression Editor: The new SQLBuilder property is added to define the query
  text formatter.
+ Expression Editor: The new ValidateContextMenu event is added to allow 
  customization of context menus.
+ The new properties were added for more customizable SQL query text formatting:
  PlainTextSQLBuilder.DynamicIndents: allows to indent the next item in the
  list to the same position as the first item;
  PlainTextSQLBuilder.DynamicRightMargin: instructs the component not to take
  into account leading spaces when counting line lenght to wrap;
  SQLBuilderFromClauseFormat: NewLineBeforeComma, NewLineAfterJoinExpression;
  SQLBuilderItemsListFormat (formats SELECT list, GROUP BY and ORDER BY items):
  NewLineBeforeComma;
= Default tab icons are refined.

December 23, 2011

Active Query Builder WinForms Edition v.1.16.0.341

- The locale-specific bug in SQLBuilder and parsers is fixed.
= DevExpress dependencies are updated to DevExpressControlFactory v.11.2.6.0.

December 21, 2011

Active Query Builder WinForms Edition v.1.16.0.340

+ The "+" button is added to the Union Navigation Bar to ease addition of new
  unions.

December 16, 2011

Active Query Builder WinForms Edition v.1.16.0.339

+ The new property PlainTextSQLBuilder.TargetQueryPart is added. It allows you
  to generate the SQL query text not for the whole query, but for active part 
  of the query only. Possible values are the following:
  Query (default): generate SQL text for the whole query;
  SubQuery: generate text for the currently active sub-query tab;
  UnionSubQuery: generate text for the currently active union sub-query.
+ PlainTextSQLBuilder.SQL property become writable to apply changes in the
  currently active query part to the query builder.
+ The new QueryBuilder.FilterTabsByActiveQueryPart property is added. It
  allows to hide the tabs that do not belong to the currently active query part.
  Possible values are the same as for the PlainTextSQLBuilder.TargetQueryPart.
+ The new source code sample "Show Query By Parts" is added to demonstrate 
  the new features.

December 09, 2011

Active Query Builder WinForms Edition v.1.15.9.338

= All properties that might be related to localization have been marked with the
 [Localizable(true)] attribute.

December 01, 2011

Active Query Builder WinForms Edition v.1.15.9.337

= DevExpress dependencies of DevExpressControlFactory are updated to 11.2.5.0.
- Added few missing project files in the source code distribution.

November 24, 2011

Active Query Builder WinForms Edition v.1.15.9.336

- Fixed: Aliases in ORDER BY are used for queries with unions only.
- Metadata object names hash was not rebuilt after MetadataContainer assignment.
- UnionSubQuery.SQL property did not remove previous union sub-query content.
  Fixed now.

November 18, 2011

Active Query Builder WinForms Edition v.1.15.9.335

+ Query Statistics: The new property CriteriaItem is added to
  StatisticsOutputColumn object. Now you may get the reference to the column
  options (sorting, filtering, etc.) by the column name (searching it in the
  StatisticsOutputColumn.ColumnName).