Downloads

Active Query Builder History History

February 10, 2012

Active Query Builder History v.1.5.3.1108

- CTE fields visibility in sub-query in some cases is fixed.
- Workaround for issues of JDBC-ODBC bridge for Microsoft SQL Server ODBC driver
  related to concurrent statements and random ResultSet fields reading is made.

February 10, 2012

Active Query Builder History 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 History 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 History v.1.5.3.1107

= Improved loading of stored procedure fields.
= 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.
- Resizing of CTE datasources on hidden tabs on field list changes is fixed.
- 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 06, 2012

Active Query Builder History 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 03, 2012

Active Query Builder History v.1.18.9

+ SQL 92, SQL 2003: Query Properties form is added to edit the DISTINCT clause.
= Now the double click on a datasource field appends it to the query column list
  but does not select it as output column.
- CTE datasources on hidden tabs are correctly resized now when on changing
  their field lists.
- PostgreSQL: Primary/foreign keys inversion is fixed.

February 03, 2012

Active Query Builder History v.1.18.9

+ SQL 92, SQL 2003: Query Properties form is added to edit the DISTINCT clause.
= Now the double click on a datasource field appends it to the query column list
  but does not select it as output column.
- CTE datasources on hidden tabs are correctly resized now when on changing
  their field lists.
- PostgreSQL: Primary/foreign keys inversion is fixed.

February 02, 2012

Active Query Builder History 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.

January 30, 2012

Active Query Builder History v.1.16.2.344

+ SQL Text Editor: The ReadOnly property is added.

January 27, 2012

Active Query Builder History 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.